Formulas in VBA runtime Error 1004

Can seem to find an issue like this on google.
I just don't understand.

Receiving a runtime error 1004 which highlights the second code snippet below.
"Application-Defined or Object-Defined error"

This works:

Formula:

Please Login or Register  to view this content.

This doesn't work:

Formula:

Please Login or Register  to view this content.

The 2nd code is directly following the first.

Any ideas?

Well... crap haha.
I did NOT expect that, considering I pasted it straight from the working formula, wow no idea how I missed that! Must have deleted a bracket by mistake after pasting, prob when adding that ending quote.
Thanks very much! Phew!