Hi Guys. Hope this is an easy one.
In my spreadsheet i want to create a macro that will copy in the contents of a named range in an external workbook (preferably without opening the external workbook). I cannot seem to be able to get the notation right to even access the external named range - i get the #name error.
my external sheet is called 'BANKSORTER.XLS' and the named range is called 'W2DATA' which is a range of about 1000 cells.
Thanks in anticipation!
In my spreadsheet i want to create a macro that will copy in the contents of a named range in an external workbook (preferably without opening the external workbook). I cannot seem to be able to get the notation right to even access the external named range - i get the #name error.
my external sheet is called 'BANKSORTER.XLS' and the named range is called 'W2DATA' which is a range of about 1000 cells.
Thanks in anticipation!