Hi Everyone
Im using the following code to query whether any of the cells form column D to Column J on the given Row have the same cell shading as the variable FindColour
However apart from being long and messy Its not returning correct results.![]()
Please Login or Register to view this content.
I.e. The rows which contain cells which are shaded the same as FindColour are being hidden.
How do i tidy this code up so that the first line isnt so long and tedious, and how do i get it to work correctly?
Regards
Bookmarks