Changing Cells Width & Height

[Sumeluar]

Hello to all!

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

Regards!
Sumeluar

 

[Legacy 63186]

try the following 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

 

[Sumeluar]

Great!
It works fine.

Regards!