Hi,
I have set my table to ListObject:
Dim my_table As Object
Set my_table = ThisWorkbook.Worksheets("Sheet1").ListObjects("Table1")
How can I find which table row is selected cell in?
I tried many ways like:
My_table.ListRows(selection.address).Range.Row
But it does not work
The answer is probably in here: https://www.thespreadsheetguru.com/b...t-excel-tables
This is an exceptionally handy reference.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks