Changing Cells Width & Height

Sumeluar

Board Regular
Joined
Jun 21, 2006
Messages
241
Hello to all!

Is there a code or any other mean to change the cells default width and height?

Regards!
Sumeluar
 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
L

Legacy 63186

Guest
try the following code

Code:
Sub test ()
Columns("A:IV").Select
    Selection.ColumnWidth = 10
Rows("1:65536").Select
    Selection.RowHeight = 20

End Sub

Change the values of 10 and 20 to suit
 

Watch MrExcel Video

Forum statistics

Threads
1,108,992
Messages
5,526,109
Members
409,685
Latest member
Bellybb

This Week's Hot Topics

Top