When I try to get the row height the returned value varies from the height in the spreadsheet. I have the row height for row 5 set to 10 but when I use the code;
Sub RowHeightTest()
MsgBox Rows(5).Height
End Sub
it returns 9.75 if I change the height to 20 I get 19.5, why is there a difference?
Try this instead.
Sub RowHeightTest()
MsgBox Rows(5).RowHeight
End Sub
Yours gives me the same issue, mine works fine for me.
Make sure you're using ROWHEIGHT, not HEIGHT.
Yours: Your non-working answer
Mine: My working answer
MsgBox Rows(1).RowHeight also works. Your problem is using Height instead of RowHeight. Please accept this answer once you can confirm.