Hi Bill thanks for your reply, unfortuantely I have tried all of these and none seem to work.
Neil.
Quote:
Originally Posted by Bill Manville
Try
..\filename.xlsx#worksheetname!A1
and, it the worksheet name contains a space, put it in quotes
..\filename.xlsx#'worksheet name'!A1
or use a defined name
..\filename.xlsx#rangename
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
|