Hi,
I have a spreadsheet where user can enter the data in a dynamic table. So the user can go to the last record and then add a record by clicking Tab on the last column of the last record.
I want to now find the ranges of the table so I can use it. How can I find the cell ranges for the table?
Learner
Perhaps:
Sheets("sheetname").ListObjects("TableName").Range.Address
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks