| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoFit macro that will not affect the header row?
I've tried:
Selection.Rows.AutoFit and ActiveSheet.Rows.AutoFit Selection.Rows.AutoFit only affects the active row one is on, which is not enough. But the ActiveSheet one affects the entire sheet, which would be okay if there were no header row. Is there a way to get the macro fine-tuned to ignore the header row, by any chance? Thanks! :oD (XL2003) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to affect all sheets | Excel Discussion (Misc queries) | |||
| Autofit (Columns.EntireColumn.AutoFit) does not work | Excel Discussion (Misc queries) | |||
| How do I stop Macro from affect other Workbooks | Excel Programming | |||
| How can I Run a query from VB macro with out affect current data in the same sheet? | Excel Discussion (Misc queries) | |||
| Add-In - OnAction Can't Find Macro & Subs Doesn't Affect Current Wkb | Excel Programming | |||
Threaded Mode
