Thank you for considering my problem!

It has been too long since i was writing code and i'm afraid my mind has stored that knowledge in some dusty old closet.


Let's say i have a defined listobject table named tblInfo with listcolumns named "One", "Two" and "Three".

Listcolumn "One" is in the worksheet's column 11 and the header row is in worksheet row 12.


Part 1:
How do i get a return value of 3 when looking for where listcolumn "Three" is in "tblInfo" instead of 13, being the worksheet column?

Part 2:
Let us say that the value "SailBoat" is in listcolumn "Three", in the 5th row of the table, being the fourth databody row.

How do i get a return of either 4 (relative to databody) or 5 (relative to the entire table) as the row "SailBoat" is in, instead of worksheet row 16?


This is so i can specifically address cells(3,5) (relative to the entire table) in tblInfo, i.e.; ActiveWorksheet.Listobjects("tblInfo").Range.Cells(3,5)

I know i can use the row and column to address that same cell using the entire worksheet as my basis, but this seems a bit, well, indiscriminate, and though i could subtract from the normal Row and Column figures the row and column that the upper left corner of my table is located in, that seems a little convoluted.

I apologize for how basic this question must be - it seems like it would be something very obvious that i must be blanking on, but so far my internet searches didn't show a simple answer.

Best Regards,
-Bruce