Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlink
Hi
I am trying to write some code to hyperlink between two worksheets.. and in the process have just about gone nuts with a syntax error I a unable to solve. Any suggestions would be appreciated. b = WorksheetB c = WorksheetC x = 4 y = 3 b.Cells(x, 8).Formula = _ "=HYPERLINK(""#""" & "ADDRESS(ROW(" & c.Cells(y, 1).Address "),COLUMN(" & c.Cells(y, 1).Address & "),,,MID(CELL(""filename""," c.Cells(y, 1).Address & "),FIND(""]"",CELL(""filename""," & c.Cells(y 1).Address & "),50)))""" Thanks in advance Pete -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste Hyperlink result as working hyperlink | Excel Worksheet Functions | |||
Can't make hyperlink function work for hyperlink to website | Excel Worksheet Functions | |||
Moving rows with Hyperlink doesn't move hyperlink address | Excel Discussion (Misc queries) | |||
Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) | |||
reading html when hyperlink address not hyperlink text diplayed | Excel Programming |