View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nora N Nora N is offline
external usenet poster
 
Posts: 1
Default Seclect Column or Range according to Cell's Contents

I need a VBA macro to do the following

I have to search for a specific word say "Sunday" within a range (A7:AJ7).
When the word is found, the column containing the cell with the word
"Sunday", or a special range within the column should be shaded.

Any help would be much appreciated