ExcelBanter - VBA Format Row Height

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - VBA Format Row Height (https://www.excelbanter.com/excel-programming/353784-vba-format-row-height.html)

gti_jobert[_29_]

VBA Format Row Height

Hi all,

Is it possible to set the row height using VBA code and not
FormatRowHeight?

Thanks all.

--
gti_jobert
------------------------------------------------------------------------
gti_jobert's Profile: http://www.excelforum.com/member.php...o&userid=30634
View this thread: http://www.excelforum.com/showthread...hreadid=514341

gti_jobert[_30_]

VBA Format Row Height

Sorry, just googled it up

Code:
--------------------

ActiveCell.EntireRow.RowHeight = 11.25

--------------------

--
gti_jobert
------------------------------------------------------------------------
gti_jobert's Profile: http://www.excelforum.com/member.php...o&userid=30634
View this thread: http://www.excelforum.com/showthread...hreadid=514341

All times are GMT +1. The time now is 05:31 PM.