set rowheight property
 

I need the syntax to set the active rowheight to 3

set rowheight property
 

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



"Ron5440" wrote in message
...
I need the syntax to set the active rowheight to 3

set rowheight property
 

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

ActiveCell.EntireRow.RowHeight = 3

--
Rick (MVP - Excel)


"Ron5440" wrote in message
...
I need the syntax to set the active rowheight to 3

set rowheight property
 

Rows(Selection.Row).RowHeight = 3

Or.

Rows(ActiveCell.Row).RowHeight = 3

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


"Ron5440" wrote in message
...
I need the syntax to set the active rowheight to 3

set rowheight property
 

ActiveCell.entirerow.height = 3

--
HTH,

Barb Reinhardt



"Ron5440" wrote:

I need the syntax to set the active rowheight to 3

set rowheight property
 

Perfect,
ThankYou

RR


"Barb Reinhardt" wrote:

ActiveCell.entirerow.height = 3

--
HTH,

Barb Reinhardt



"Ron5440" wrote:

I need the syntax to set the active rowheight to 3