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