| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can we write VBA code to set all column/row's size back to default size?
Somthing like one of these may work...
a. Worksheets("Sheet1").Range("A1:D8"). _ AutoFormat Format:=xlRangeAutoFormatClassic1 b. Columns("E:E").EntireColumn.AutoFit You will have to play with these, and the Range/Columns as required. -----Original Message----- VBA code changes the Excel column/row size, Can we write VBA code to set all column/row's size back to default size? Thanks in advance! . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| is there a code to set the default view size in Excel | Excel Discussion (Misc queries) | |||
| how do i reformat text size in all comment boxs to a default size | Excel Worksheet Functions | |||
| save as bring up full screen how do I get back to normal size | Excel Discussion (Misc queries) | |||
| My tabs' font size is smaller - how do I restore default size? | Excel Discussion (Misc queries) | |||
| Changed column width keeps reverting back to original size | Excel Discussion (Misc queries) | |||
Threaded Mode
