hello,

I'm trying to write some code that will check the cell colour of 11 adjacent cells in a row. Having done that the whole thing repeats with a do/loop a couple of thousand times down the active sheet.

I thought about using: ACTIVECELL.OFFSET(.....) but this option won't allow variable substitution in the form of: ACTIVECELL.OFFSET(0,X) where X increments from 1 to 11.

Not sure if I'm making this clear but if anyone manages to get their head around my problem and can come up with a solution, I'd be very much obliged.

Thanks, Mike