Excel Table Range

[lulupatel]

Dear Sir

Please help on this

I have a table name with XYZ, this table is on sheet1!C2:F25.

is there any formula or VBA function I can get this Range. as I want to see in msgbox {"XYZ table is on sheet1!C2:F25"}

[Pauleyb]

Range("XYZ").address will give you the address without the sheet name. To get the sheet name use Range("XYZ").Parent.name. Concatenate as needed.

[lulupatel]

Thank Sir

its working amezzing

[lulupatel]

sir

its getting only body data

is it possible to get with header range also

[Pauleyb]

The header is not part of the named range. You can 'work around' this:
range("XYZ").offset(-1,0).Resize(range("XYZ").Rows.Count+1, range("XYZ").Columns.Count).Address