(Solved) – vba get range of specific cells in a table (listobject)

  • by
(solved)-–-vba-get-range-of-specific-cells-in-a-table-(listobject)

I am trying to have my code refer to ranges only through tables (so that if I add or remove a column from a table, the code will not change).
I have a table that is called MyTable.
This table has a header ‘MyHeader’.

Here I get the last last row of the table:

dim numRecords as integer
numRecords  = sheet1.listobjects("MyTable").listRows.count 

Now I have a function that receives a range type argument and puts something in this range.

I want the function to receive the cell that is on column ‘MyHeader’ and row number numRecords . How would I get the range of this cell (with referring only to the table and not to the rows or columns of the sheet)?

Thanks

Leave a Reply

Your email address will not be published. Required fields are marked *