retrieving excel row height

[rrakanishu]

VB6
have an excel sheet open, all works well.

I want to retrieve the height of a row and i cant seem to find any function to do it

more precisely i want to do something like

For i = 1 To range.rows.count
    Msgbox worksheet.row(i).height
Next i

only problem is worksheet.row doesnt have an index or any properties... nor does anything else i have been able to find.

Thanks

[culloden]

Use RowHeight instead of height.