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!