![]() |
Table range coordinates?
I have a table that shows up in Excel in a drop down. I want to find out the
upper left cell coordinates and the lower right cell coordinates. I see from the documentation that there are Column(s) and Row(s) along with Cells. But how would be the best way to get the range of a table? The table was added to a worksheet ListObjects. How do I query this object using VSTO. I would like to read this information from VSTO rather than cache the range values as needed. So two questions: 1) How do I get the range associated with a "ListObject"? Is it a table, named range, etc.? 2) Once I have the range (Excel.Range) how do I get the upper and lower coordinates(column and row) for the range? Thank you. Kevin |
All times are GMT +1. The time now is 07:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com