Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel Background Color
Message
 
 
To
28/06/2005 14:34:19
John Tomblin
Service Station Systems, Inc.
San Jose, California, United States
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01027160
Message ID:
01027234
Views:
10
>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?

The code you're using is a correct way to set background color. I'm not sure why it doesn't work for you. Maybe your monitor is out of blue ink? :)
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform