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
ActiveSheet.Rows.EntireRow.RowHeight = ActiveSheet.StandardHeight
ActiveSheet.Columns.EntireColumn.ColumnWidth = ActiveSheet.StandardWidth
hth
Charles
______________________
Decision Models
The Excel Calculation Site
www.DecisionModels.com