| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofit for entire sheet?
I know this:
Worksheets("Results").Range("a1:c1").Columns.AutoF it But I want it for the entire document.... basically I know "c" as a number, but I dont know the row count. What properties can I use (which I cannot find in the help) /S |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Autofit for entire sheet?
worksheets("Results").columns.Autofit
for rows worksheets("Results").Rows.autofit -- Regards, Tom Ogilvy "Sonnich" wrote: I know this: Worksheets("Results").Range("a1:c1").Columns.AutoF it But I want it for the entire document.... basically I know "c" as a number, but I dont know the row count. What properties can I use (which I cannot find in the help) /S |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| transfer entire row to another sheet | Excel Discussion (Misc queries) | |||
| Autofit (Columns.EntireColumn.AutoFit) does not work | Excel Discussion (Misc queries) | |||
| Copy the entire sheet to overlay existing sheet? | New Users to Excel | |||
| Subtract entire sheet? | Excel Worksheet Functions | |||
| Macro to look for blank rows in sheet, delete the row and autofit | Excel Programming | |||
Linear Mode
