Re: Can we write VBA code to set all column/row's size back to default size?

  • Thread starter Thread starter Charles Williams
  • Start date Start date
C

Charles Williams

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
 
Back
Top