I would like to be able to insert the following through a macro:

=HYPERLINK("https://emea.salesforce.com/search/SearchResults?searchType=1&sen=0&setLast=1&sbstr="&A1&"&search=+Go%21+","search "&A1&"")
where A1 actually equals RC[-1]

I know it is a question of inverted commas, as I had it working once before.

Thanks,

Jack