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