If I have the range H2:H150,
I need a macro that will go through that range, and if it finds a cell that is filled grey (color index = 15), it will change that entire row to fill black
Everybody's help is always appreciated. thank you
If I have the range H2:H150,
I need a macro that will go through that range, and if it finds a cell that is filled grey (color index = 15), it will change that entire row to fill black
Everybody's help is always appreciated. thank you
Try
VBA NoobPlease Login or Register to view this content.
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
beautiful! worked like a charm.
Thanks for all your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks