Hyperlink To A Specific Worksheet in Excel 2007
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
|