Access to range defined by a Table Name

[RolandTLH]

Hi,

thank you for the library. It's very useful. I'm using a lot of Structured References (also called "Table Name") in my Excel Sheets for different reasons.

In VBA, I can access these ranges by its name like any range. For example, a table défined by the range "A1:B5" named "MyRange" can be accessed both ways : range("A1:B5") or range("MyRange").

It's interesting when you have different tables in the same sheets and when their ranges are not know a priori.

Is it possible to do it the same way through the "range" attribute of your method ?

thanks a lot.

Regards

[TheSchemm]

I came here to see if this issue existed. I am working on a project now that would benefit a lot from this.