how to set row size?

[bhandari]

Sub Rsize()
   Rows("7:7").Select
    Selection.RowHeight = 20
    Rows("16:16").Select
    Selection.RowHeight = 20
End Sub

is it possible to use array macro?

 

[Joe4]

Is that what you are trying to do?

Sub Rsize()
   Range("7:7, 16:16").RowHeight = 20
End Sub

You can keep adding more rows, separated by commas.

 

[bhandari]

Thank you Joe4

 

[Joe4]

You are welcome.

 

[Rick Rothstein]

Is that what you are trying to do?

Sub Rsize()
   Range("7:7, 16:16").RowHeight = 20
End Sub

You can keep adding more rows, separated by commas.

There is a maximum size that needs to be respected though... the total length of the text argument to the Range object is either 255 or 256 total characters.

 

[bhandari]

Very informative @Rick Rothstein