Solved: Autofit alternating sizes

[Djblois]

Now I am autofiting the columns but they can be all different sizes. This is what I have so far and it doesn't work.

Range("A2:1" & finalColumn).AutoFit

[Marcster]

Columns("A:" & finalColumn).AutoFit

Marcster.

[CBrine]

I think your range reference is kinda messed up.

Try this.

Range("A2", Cells(1, finalcolumn)).EntireColumn.AutoFit


HTH
Cal

[CBrine]

Djblois,
Is you finalcolumn variable a numeric column index? If it is, use mine. If it's a letter use Marcster's.

Cal

[Djblois]

Thank you that worked