What is the syntax to change row height?

Rows(“<row number>”).RowHeight = <height in pixels>

Bear in mind that standard row height in Excel is 8.43.

‘examples
Rows(2).RowHeight = 4
Rows(“3:9”).RowHeight=20
Advertisements