set rowheight property

[Ron5440]

I need the syntax to set the active rowheight to 3

 

[JLGWhiz]

With Worksheets("Sheet1").Rows(1)
.RowHeight = .3
End With

 

[Rick Rothstein]

If you mean you want to set the RowHeight for the row that the ActiveCell is
in...

ActiveCell.EntireRow.RowHeight = 3

 

[JLGWhiz]

Rows(Selection.Row).RowHeight = 3

Or.

Rows(ActiveCell.Row).RowHeight = 3

The row object has to be specified for the RowHeight property to work.

 

[Barb Reinhardt]

ActiveCell.entirerow.height = 3

 

[Ron5440]

Perfect,
ThankYou

RR

ActiveCell.entirerow.height = 3