ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Table range coordinates? (https://www.excelbanter.com/excel-programming/412826-table-range-coordinates.html)

Kevin Burton

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