• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. T

    If any part of text in cell range contains a value

    Faseeh, Thank you. Just what I needed. Works perfectly!
  2. T

    If any part of text in cell range contains a value

    I have a spreadsheet with colors listed in cells. The cell may contain the name of the color, plus other text. I am looking to return a value of True or False if any cell in the range contains yellow or red. Below are some examples of what cells in the range may contain. As you can see. I...
  3. T

    Macro copies to create new worksheets. Worksheets open slow!

    Unfortunately I still have the same issue. It runs slowly and anytime that I reopen the spreadsheet.
  4. T

    Macro copies to create new worksheets. Worksheets open slow!

    I have a macro that is design to import data from a CSV file into a formatted spreadsheet. A copy of the sheet is then created and a filter applied based upon a name in a column. Three sheets are created to this way, each with info filtered to only display a particular person's rows of data...
  5. T

    Set Range to C5:E5 xldown

    Never mind! If I use what you wrote above and use .Range("E5", .Range(C5") it works just fine! Luke, Thank you for your help! You made my afternoon much more productive! Appreciate the response and assistance!
  6. T

    Set Range to C5:E5 xldown

    Getting closer! Columns C and D are part of a Pivot table. Column E has a formula that calculates based upon the values in the same row in C and D. The spreadsheet contains many more rows in Column E, than in C or D. They are conditionally formatted to hide the text if there is nothing...
  7. T

    Set Range to C5:E5 xldown

    Trying to set a range. This would be based on a dynamic set of data. The data is in C5:E5 with a variable number of rows. Can't see to get this one correct. Here is what I am currently using. Set rng = Sheets("Total Hours by Manager").Range("C5:E5").Select Range(Selection...
  8. T

    Paste Excel Range into Body of Email

    Thank you for the pointer. Unfortunately I still get -1 as the body of the message. :(
  9. T

    Paste Excel Range into Body of Email

    Here is version 2, which also pastes "-1" into the message body. Sub sendMail() Sheets("Total Hours by Manager").Select Dim objOutlook, objMsg, objNameSpace, objFolder, strOutput, strSubject, StrMsg StrMsg = ActiveSheet.Range("C5:E150").Copy StrSbj = "Bi Weekly Time Reporting" Const...
  10. T

    Paste Excel Range into Body of Email

    I am stuck. I am trying to create a macro that will copy an excel range into the body of an email. I would prefer to use HTML to retain the formatting. Range is C5:E5 xldown I can send the email with the workbook as an attachement (which I want), I just can't seem to get the range in the...
  11. T

    Pivot Table Macro - Filter out anything containing one of two values [SOLVED]

    This works! I do have a pretty large data set so if you have another approach that will speed up the process I would welcome the information! Thank you both for your help! It is greatly appreciated!
  12. T

    Pivot Table Macro - Filter out anything containing one of two values [SOLVED]

    Deb, Thank you again! This runs perfectly! The only change would be that I want to show everything except those items that have Hosting or Infrastructure in the title. In regard to the names I thought I deleted them out, but apparently that did not truly remove them, so VBA picked it up...
  13. T

    Pivot Table Macro - Filter out anything containing one of two values [SOLVED]

    Here you go:) https://docs.google.com/file/d/0BxhVKid9p8IBMjFUUk04S3JhR3c/edit?usp=sharing
  14. T

    Pivot Table Macro - Filter out anything containing one of two values [SOLVED]

    I am still getting the same error on this row [PTitle.PivotItems(i).Visible = True] You are correct though, the pivot item only contains the words and may not be an exact match. Thanks for your continued help!
  15. T

    Pivot Table Macro - Filter out anything containing one of two values [SOLVED]

    I can email or post the workbook if it helps.
  16. T

    Pivot Table Macro - Filter out anything containing one of two values [SOLVED]

    Deb, Thank you for your help! I get a Run-time 1004 error "Unable to set the Visible property of the PivotItem class" occurring on the [PTitle.PivotItems(i).Visible = False] line. It also filtered out everything except one result, but that result contained Infrastructure Support Agreement...
  17. T

    Pivot Table Macro - Filter out anything containing one of two values [SOLVED]

    I am trying to write a macro that will filter a pivot table. I want to filter out anything that contains one of two values; "Hosting", and "Infrastructure". I am getting an error on the following macro. It will only filter out the first value. I have tried multipe versions and cannot seem to...
Back
Top