Quotes in .formula calcs
 

I would like to put:

HLRange.Formula = "=Hyperlink('file:\\Server1\test.pdf')"

in code but I get a run time error-1004 message, can someone help with the
formatting on this.

Quotes in .formula calcs
 

HLRange.Formula = "=Hyperlink(""file:\\Server1\test.pdf"")"

You have to double up your double quotes inside that string.

Paulymon wrote:

I would like to put:

HLRange.Formula = "=Hyperlink('file:\\Server1\test.pdf')"

in code but I get a run time error-1004 message, can someone help with the
formatting on this.

--

Dave Peterson