Row Height Code

Can someone tell me the VB/Macro code to set the height of a row/rows.

Hi IceTray,

> Can someone tell me the VB/Macro code to set the height of a row/rows.

Try:

Range("A1:A4").RowHeight = 20


---
Regards,
Norman

Dim Rng As Range
Dim Ht As Integer
Set Rng = Rows(1)
Ht = 25
Rng.RowHeight = Ht

HTH

Duncan


icetrey wrote:

> Can someone tell me the VB/Macro code to set the height of a row/rows.
>
>
> --
> icetrey
> ------------------------------------------------------------------------
> icetrey's Profile: http://www.excelforum.com/member.php...o&userid=20329
> View this thread: http://www.excelforum.com/showthread...hreadid=564216

It worked for me. Thanks.