Worksheets("Dashboard").Columns("E").AutoFit

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"DawnTreader" wrote in message
...
Hello All

ActiveWorkbook.Worksheets("Dashboard").Columns("E: E").EntireColumn.AutoFit

do i need to do the entire column? or does the E:E take care of that?

sometimes it comes up with an error saying that the range isnt available
for
autofit, or something like that.

any and all help appreciated.