>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--