Hi
I have a large workbook with upto 50 sheets - each sheet has a range of 20 col and 20 rows. Each range has a unique name that starts with "Range".
I have tried to set up a Query in the workbook to retrieve ranges in the workbook where the name starts with "Range". However it takes 5-10 minutes to make teh conection.
Is there a way I can get it to just pull ranges where the range name starts with "Range".
The attached file is very small and simple but is supplied to facilitate a solution.
Kind Regards
Allister
Bookmarks