Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm trying to set the background color for the entire worksheet. If there's
a quicker way to do this, other than by grabbing a reasonably large range, then please let me know and I'll use that approach: Here's the approach I am attempting: TargetWorksheet.Range("A1:AZ1024").Interior.Color = SourceWorksheet.Cells(1, 1).Interior.Color What I'm doing is setting the color of the target worksheet to the color of the source worksheet. The color I expect is: C1 9B 7C or 12688251 - a nice pale blue. I've verified that SourceWorksheet.Cells(1, 1).Interior.Color does in fact evaluate to 12688251, but what I'm actually seeing is light grey, rather than pale blue. Even if I try this using the desired value as a literal constant, I still get the light grey. I know the code statement is doing something, since without it the target worksheet shows up white and a literal constant of 0 gives me a black backgound, &HFF00FF gives me bright lavender, but for some reason, C19B7C (12688251) gives me light grey, even though in the source worksheet is shows nicely as pale blue. What am I doing wrong? Thanks! - Joseph Geretz - |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need Help Setting background color in XLM Excel worksheets in Netscapeand Firefox browsers | Excel Programming | |||
Setting Background Color RGB (Always goes to closest index color) | Excel Programming | |||
Conditionally setting background color of a cell | Excel Discussion (Misc queries) | |||
worksheet background color | Excel Discussion (Misc queries) | |||
Setting cell background color based on value | Excel Programming |