Hyperlink
Hello again, Stew.
You will need the sheet name as well as the column letter and row
number, but you will also need to have square brackets around the
filename and two apostrophes. So, try this:
=HYPERLINK("'"&LEFT(CELL("Filename",A1),SEARCH("[",CELL("filename",A1))-25))&"M*
erchandise Package\[Mechandise Spreadsheet.xls]Sheet1'!
A"&((ROW()-4)*103+8),"View")
I assume that the LEFT function does return the full path to that
point and ends in \.
Hope this helps.
Pete
On Nov 4, 8:29*pm, stew wrote:
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))&"M*erchandise Package\Mechandise Spreadsheet.xls"
Ideally it would be along the lines of "&((ROW()-4)*103+8),"View")
Thanks
Stew
|