a little help with an non critical but annoying error

D

DawnTreader

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.
 
J

Jacob Skaria

Try
ActiveWorkbook.Worksheets("Dashboard").Columns(5).EntireColumn.AutoFit

If this post helps click Yes
 
R

Rick Rothstein

Jacob
========
You don't need the EntireColumn reference since the Columns property
provides that...

ActiveWorkbook.Worksheets("Dashboard").Columns(5).AutoFit

Dawn
=======
Just so you know, you can use the column letter instead of the column number
code if you prefer...

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

Jacob Skaria

Thanks Rick..

Rick Rothstein said:
Jacob
========
You don't need the EntireColumn reference since the Columns property
provides that...

ActiveWorkbook.Worksheets("Dashboard").Columns(5).AutoFit

Dawn
=======
Just so you know, you can use the column letter instead of the column number
code if you prefer...

ActiveWorkbook.Worksheets("Dashboard").Columns("E").AutoFit
Click to expand...
 
Top