Is it possible to conditional format a range of cells if the active cell is not in the range to be formatted?

I get a Runtime 9 error with the following code if I comment out the Range("H1").Activate line.
If I don't comment it out the code does what it is supposed to, however, I am trying to avoid "activate" or "select" for efficiency because I will need to loop the code through thousands of tabs.


Please Login or Register  to view this content.

Any assistance appreciated.