View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Greg Spencer Greg Spencer is offline
external usenet poster
 
Posts: 2
Default Searching for a string and then shading the row

Being new to VBA programming, I'm struggling to put together a macro that
will accomplish the following:

1. Search the cells in a specific column (H) - starting at row 3 - for the
presence of a particular word from a list of 3 different words.

2. If one of the words is found, the entire row (from columns A through H)
would be shaded.

3. The search would continue through the rest of the cells in the column
with the same action being repeated to the end of the column.

All help would be appreciated!