Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
worksheet cells fill with color after typing | Excel Discussion (Misc queries) | |||
link color fill from one worksheet to another | Excel Discussion (Misc queries) | |||
How do I view Fill Color selected on my worksheet? | Excel Discussion (Misc queries) | |||
fill cell with color from other worksheet | Excel Discussion (Misc queries) | |||
fill row color on a specified worksheet | Excel Programming |