Hyperlink To A Specific Worksheet in Excel 2007
Hi Bill thanks for your reply, unfortuantely I have tried all of these
and none seem to work.
Neil.
Bill Manville;941191 Wrote:
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
--
neilw2194
|