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!