I have tried this and cant get it to work
The name range can continually change depending on the users preference
For example, the file contains 100 different tables - Table_1 - Table_100
The user has a drop down where they can choose whichever table they wish - a formula is written which refers to this name, and gives you the defined name of the range for that table.
I then need to use this defined name to find the table in the file somewhere, and paste the range.