Row Height Code
 

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

Row Height Code
 

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

Row Height Code
 

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

Row Height Code
 

It worked for me. Thanks

--
icetre
-----------------------------------------------------------------------
icetrey's Profile: http://www.excelforum.com/member.php...fo&userid=2032
View this thread: http://www.excelforum.com/showthread.php?threadid=56421