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
VB Code:
  1. For i = 1 To range.rows.count
  2.     Msgbox worksheet.row(i).height
  3. 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