G Gary''s Student Feb 12, 2009 #2 To get the height of a row: Sub bigmac() MsgBox (ActiveCell.RowHeight) End Sub To set the height of a row: Sub littlemac() ActiveCell.RowHeight = 20 End Sub
To get the height of a row: Sub bigmac() MsgBox (ActiveCell.RowHeight) End Sub To set the height of a row: Sub littlemac() ActiveCell.RowHeight = 20 End Sub
J JLGWhiz Feb 12, 2009 #3 This site explains row height and column width. http://office.microsoft.com/en-us/excel/HA101375451033.aspx?pid=CL100570551033
This site explains row height and column width. http://office.microsoft.com/en-us/excel/HA101375451033.aspx?pid=CL100570551033