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

  • Thread starter Charles Williams
  • 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
 

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

Can we write VBA code to set all column/row's size back to default size? 0
Formula, Macro, or VBA code to find and insert 3
Using A Macro/VBA code to re-set formulas 4
How to get each table's first line of record and write into excel? 3
importing more than 65536 rows from .csv file 1
VBA code in one Module referencing Public Variables Declared inanother Module failing 5
Running VB Code 1
A few questions, if somebody could please assist -i've been doing my head in to get my vba project c 1

Top