fill row color on a specified worksheet
 

if you have an unqualified range, it refers to the active sheet.

to be specific, qualify your range

worksheets("Sheet2").Range("2:3").Interior.ColorIn dex = 5

--
Regards,
Tom Ogilvy



"Jeff" wrote in message
...
I am trying to fill 2 colors on different rows on the 2nd worksheet. the
colors are filled to the right rows, but wrong worksheet (it always fills
the
1st worksheet instead).