Table range coordinates?

K

Kevin Burton

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top