Hi Everyone,

I have a Macro that Produces Results Starting in "A1" and Continues
Vertically. The Results Could Possible Use Several Columns. I have Tried
Using the Following Code to Set the Columns "A:IV" to be AutoFit,
Centred and Texted, But for Some Reason it will NOT Work.
Has Anyone got Any Suggestions Please. Here is the Code :-

Sheets("Results").Select
Columns("A:IV").AutoFit
Columns("A:IV").HorizontalAlignment = xlCenter
Columns("A:IV").NumberFormat = "@" ' Set to Text.
Range("A1").Select

Thanks in Advance.
All the Best
Paul
Windows XP - Excel 2002

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!