Search results

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

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...

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

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...

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!

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...

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...

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

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...

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...

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!

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...

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

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!

I can email or post the workbook if it helps.

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...

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...