R
Ron5440
I need the syntax to set the active rowheight to 3
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JLGWhiz
With Worksheets("Sheet1").Rows(1)
.RowHeight = .3
End With
.RowHeight = .3
End With
R
Rick Rothstein
If you mean you want to set the RowHeight for the row that the ActiveCell is
in...
ActiveCell.EntireRow.RowHeight = 3
in...
ActiveCell.EntireRow.RowHeight = 3
J
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.
Or.
Rows(ActiveCell.Row).RowHeight = 3
The row object has to be specified for the RowHeight property to work.
B
Barb Reinhardt
ActiveCell.entirerow.height = 3
R