View Single Post
  #2  
Old March 30th, 2010, 08:01 AM posted to microsoft.public.excel.links
Bill Manville
external usenet poster
 
Posts: 258
Default 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

Ads