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!
.