for each sh in Thisworkbook.Worksheets
sh.Range("F:F,H:H,L:M").EntireColumn.Autofit
Next

--
Regards,
Tom Ogilvy

"tratliff " wrote in message
...
I have a workbook with @50 tabs. Each tab is setup the same. I want to
autofit certain columns (F, H, L, M) on all tabs. There are hidden tabs
(G, I, J, K) that I do not want to autofit.

please help!!!


---
Message posted from http://www.ExcelForum.com/