Referencing 2 separate worksheets in a macro

Hi all,

I am trying to write a macro that runs through each cell in the active work sheet (this work sheet will constantly vary) and make a comparison to a cell in a set work sheet (will not vary) and if a condition is met, an action is taken in the non-varying work sheet.

I am still trying to pick up on VBA syntax and I'm having trouble with the macro, here is a very crude version of what I want:

For Each c In [A1: CQ120]
IF activeworksheet.c.Interior.ColorIndex = ClrIndexr1 AND Sheets("Non-Varying Sheet").c.interior.colorindex = 2 THEN Sheets("Non-Varying Sheet").c.interior.colorindex = 3

Cheers,

Beck

Don't think your that far off. Try:

Please Login or Register  to view this content.