Ah, you're populating the cell in code.

You may want to change the D5 to R5C4 since you're using R1C1 reference style
(or just use .formula).

And if you have trouble, you may need to make it look more like:

Range("H9").Formula = _
"=HYPERLINK(""file:////G:/Real Estate/Shared/Offline Packages/""" & _
"&D5&""/PCR.PDF"",""PCR"")"

akronpow wrote:

The resulting hyperlink formula is:

=HYPERLINK("G:\Real Estate\Shared\Offline Packages\& D5
&\PCR.PDF","PCR")

and I need the "& D5 &" part to show the result of cell D5.

Here is the code as used:

Range("H9").FormulaR1C1 = _
"=HYPERLINK(""G:\Real Estate\Shared\Offline Packages\& D5
&\PCR.PDF"",""PCR"")"

--
akronpow
------------------------------------------------------------------------
akronpow's Profile: http://www.excelforum.com/member.php...o&userid=29100
View this thread: http://www.excelforum.com/showthread...hreadid=488213

--

Dave Peterson