Hyperlink

[Quadzer]

Can anyone tell me why this does not work?

Worksheets("PR Database").Range("C3").Value = "=HYPERLINK("[PR 2015.xlsm]4!A4","test")"

I want to place a Hyperlink in sheet PR Database cell C3 that points to sheet 4 cell A4 and called test

Thanks for any and all help.

 

[Jerry Sullivan]

Hi and Welcome to MrExcel,

There's a few syntax errors that keep that from working:
1. Single quotes are needed around a workbook or worksheet reference that includes spaces.

2. Literal quotes in a formula need to be doubled up in VBA expressions.

3. A "#" is needed in a hyperlink expression to reference a range in an open workbook if the full filepath is not specified.

Try....

 Worksheets("PR Database").Range("C3").Formula = _
   "=HYPERLINK(""#'[PR 2015.xlsm]4'!$A$4"", ""test"")"