General information
Category:
COM/DCOM and OLE Automation
Title:
Excel Background Color
I am attempting to set the background color of the headder in an Excel spreadsheet using Office automation.
oSheet.Range("A1:AG2").Interior.Color = rgb(0,0,255)
should make the background blue. It doesn't. It makes a blue dot, speckled pattern instead. I simply want a solid blue background. I tried setting the pattern to solid and to none with the same effect.
oSheet.Range("A1:AG2").Interior.Pattern = 1 && Solid
Can anyone help me get a solid color background for a set of cells?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only