J
Joseph Geretz
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 -
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 -