That doesn't need to be in quotes so:

ActiveCell.Formula = "=HYPERLINK(""http://www.mysite.com/search/searchresults.aspx?zp=""&V2&""&typ=7"",A2)"
Richard