set column width excel macro code example

Example: vba set row height

Sub RowHeight()
    Rows("1:1").RowHeight = 30
End Sub