| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Critical requirement. | Excel Worksheet Functions | |||
| annoying subscript out of range error | Excel Programming | |||
| Critical graph | Excel Discussion (Misc queries) | |||
| Why did I get an unexpected critical error? | Excel Discussion (Misc queries) | |||
| VB Critical 400 | Excel Programming | |||
Linear Mode
