a little help with an non critical but annoying error
 

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.

a little help with an non critical but annoying error
 

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

If this post helps click Yes
---------------
Jacob Skaria


"DawnTreader" wrote:

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.

a little help with an non critical but annoying error
 

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

--
Rick (MVP - Excel)


"Jacob Skaria" wrote in message
...
Try
ActiveWorkbook.Worksheets("Dashboard").Columns(5). EntireColumn.AutoFit

If this post helps click Yes
---------------
Jacob Skaria


"DawnTreader" wrote:

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.

a little help with an non critical but annoying error
 

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.

a little help with an non critical but annoying error
 

Thanks Rick..

"Rick Rothstein" wrote:

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

--
Rick (MVP - Excel)


"Jacob Skaria" wrote in message
...
Try
ActiveWorkbook.Worksheets("Dashboard").Columns(5). EntireColumn.AutoFit

If this post helps click Yes
---------------
Jacob Skaria


"DawnTreader" wrote:

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.