If Or Statement Help

[jordan2322]

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

Please Login or Register  to view this content.

However apart from being long and messy Its not returning correct results.
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

[JapanDave]

You could do this?

Please Login or Register  to view this content.

[jordan2322]

Thanks for your reply JapanDave

i used the following code inlieu of yours

Please Login or Register  to view this content.

I ran into a few problems using other methods and this one worked out fine for me .. for now
cheers!

[JapanDave]

Glad I could help. Thanks for marking the thread solved.