Insert Row question

[Stuart]

How do I insert a row, with a specific rowheight, please?

Regards.

 

[Frank Kabel]

Hi
try something like
....
row_height=5
ActiveCell.Resize(row_height,1).EntireRow.insert

 

[SOS]

Stuart,

Use a With Statement to insert where you want with the row height yo
want as seen below

Regards

Seamus


Sub Insert_Row()
With Rows("6:6")
.Insert Shift:=xlDown
.RowHeight = 25.5
End With
End Su