Search code examples
excelvbarangelistobject

Extract address cell in table


I would like to have the range (address) of the cell where is my table like :

Column = Range(table_NB.DataBodyRange(1, 1))

Do you have the correct code for this ?


Solution

  • To get the address of the first cell in a table:

    MsgBox ListObjects(1).DataBodyRange.Cells(1, 1).Address