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

Click here to load this message in the networking platform