I have been working on this macro that creates a Hyperlink to the cell, the file path is uniformed except for one variable ????? which is located to the left of the cell but I can't seem to get this to feed through. I have probably got some of the syntax wrong for what I want to accomplish and would very much appreciate some help on the issue.
Thanks in advance
Sub Hyperlink() ' ' Hyperlink Macro ' Macro recorded 04/06/2010 by Joe Bushfield ' Keyboard Shortcut: Ctrl+Shift+Y ' ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _ "C:\Documents and Settings\JBushfield\Desktop\PDF_Shortcuts\Shortcut to " & [COLOR=blue]?????[/COLOR] & ".pdf.lnk" _ , TextToDisplay:= _ "Go to ebook" ActiveCell.Offset(1, 0).Select End Sub