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

E

Earle

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Pivot Table Error 1
VBA code for pasting links -- modifying RDB code for summary workbook 11
I must make certain I have a specific range of numbers present. 3
vba to copy data from sale receipt to next available column in aninventory worksheet 0
Copying Data Down the Column But Only Based on What's in Column A 3
10 seconds to open excel workbook w/macros 1
Miscellaneous VBA Questions 4
vba to copy data from sale receipt to next available column in an inventory worksheet 0

Top