View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David McRitchie
 
Posts: n/a
Default Hyperlink function fails when using variable row number

It mitght be noted that if you just have one word for the sheet name and
surround it by single quotes like you would if you had two or more words
that the single quotes will disappear automatically. Which may account
for some of the confusion. experienced.

The more complicated formula does *exactly* the same, it is just coded
to remove place the sheetname and cell outside of the double quotes.