Hyperlink variable in formula syntax

I'm trying to pass a cell reference in a hyperlink as a formula like this:

'ActiveCell.FormulaR1C1 = "=HYPERLINK(""http://www.mysitr.com/search/searchresults.aspx?zp=""&A2&""&typ=7"",""zip search"")"

but get an error. How do I handle the quotes around the cell?

Outside of a formula, this works:
=HYPERLINK("http://www.mysite.com/search/searchresults.aspx?zp="&A2&"&typ=7","zip search")

Thanks in advance!

Hi

Your error is being caused by you mixing A1-style references in your formula string with the FormulaR1C1 property of the cell. Change to:

Please Login or Register  to view this content.

Richard

Thank you! One more question, what's the syntax for the 2nd part (link name)? I want to use the value of A2 as the name.

Please Login or Register  to view this content.

That doesn't need to be in quotes so:

Please Login or Register  to view this content.

Richard

Thank you!