Search results

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

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

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

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

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