Autofit Columns...

[dBjason]

I'm trying to autofit column width through VBA (like when you double-click inbetween columns). Any ideas?

 

[FXP]

Try:


Cells.Select
Cells.EntireColumn.AutoFit

 

[SkipVought]

Hi,

all you need is...

Sheets("yourSheetName").cells.entirecolumn.autofit

You so NOT need to use the Select or Activate methods!

Skip,

_{[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart!}