find row and column in table

[storm8]

Hi, I set listobject.databodyrange as range and then I loop trough each cell and want to find find out what row and column the cell is in the table (so I can get first row/column values as variables), but I cannot figure out how to do this.

cell.listobject.row would not work and did not found anything that would help.

any suggestions?

thank you.

 

[Jameo]

Sub test()
Dim UsedRng As Range
Dim FirstRow As Long, FirstCol As Long, FirstVal As Double
Set UsedRng = ActiveSheet.UsedRange
FirstRow = UsedRng(1).Row
FirstCol = UsedRng(1).Column
FirstVal = Cells(FirstRow, FirstCol).Value
End Sub

 

[storm8]

this doesn't work: it gives me address of cell relative to worksheet, but I need it relative to table (listobject). eg if my table databodyrange is b3:F7 i want to get row and column of each cell in databodyrange, so the first result would be R1C1, next one R1C2 etc...