View Single Post
  #3  
Old March 30th, 2010, 07:07 PM posted to microsoft.public.excel.links
neilw2194[_2_]
external usenet poster
 
Posts: 1
Default 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