| 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?
You can use the worksheet standaheight and standardwidth properties
ActiveSheet.Rows.EntireRow.RowHeight = ActiveSheet.StandardHeight ActiveSheet.Columns.EntireColumn.ColumnWidth = ActiveSheet.StandardWidth hth Charles ______________________ Decision Models The Excel Calculation Site www.DecisionModels.com "d" wrote in 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! |
| Reply |
| 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 | |||
| 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) | |||
| Can we write VBA code to set all column/row's size back to default size? | Excel Programming | |||
Linear Mode
