P
Paul Black
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
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