Thread: Hyperlink
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SteW SteW is offline
external usenet poster
 
Posts: 293
Default Hyperlink

Hi all

In this Formula how would one add the exact cell you would want to open at
=HYPERLINK(LEFT(CELL("Filename",A1),SEARCH("[",CELL("filename",A1))-25))&"Merchandise Package\Mechandise Spreadsheet.xls"
Ideally it would be along the lines of "&((ROW()-4)*103+8),"View")

Thanks

Stew