excel automatic formatting 1

[evilmousse]

I'm attempting to format an automatically output excel file
before the user receives it. I've succeeded in freezing the panes as I need to, but I'm having some troubles setting the background color of the title row. I can see the code I already have does indeed set the bg color, but then it is set away again. All of it happens in a flash, but not so fast I couldn't spot it happening.

here's my code:

Rows("1:1&quot.Select
With Selection.Interior
.ColorIndex = 6
.PatternColorIndex = xlAutomatic
End With

thx in advance
-g

 

[SkipVought]

Hi,

Something else must be happening further down in your code.

All you need is...

Rows("1:1").Interior.ColorIndex = 6

Check my FAQ faq707-4105



Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[evilmousse]

Hunh.
Worked.
I wish i had the spare time to spend figuring out the difference between our code.
thanks much.

-g

 

[Bowers74]

You only need the time to read Skip's FAQ: faq707-4105

That Should show you the difference!



Peace!

Mike

Never say Never!!!
Nothing is impossible!!!