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
|