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
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