Thread: Can we write VBA code to set all column/row's size back to default size?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Earle Earle is offline
external usenet poster
  
Posts: 2
Default 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!
.

Reply With QuoteReply With Quote