VBA Auto Size Columns Quick Question

[SamBo1234]

Hi All,

Just a quick one,

Im trying to select columns A:H and auto size them.

Im using the following code

Columns("A:H").Select
Selection.Columns.AutoFit

It works but i dont want it to take notice of the long string i have in A1 as its the title of the data....

Any suggestions ?

 

[pgc01]

Hi SamBo1234

Deal with column A separately.

Please try:

Range("A2:A" & Rows.Count).Columns.AutoFit
Columns("B:H").AutoFit

Hope this helps
PGC