inserting a formula with VBA that has quotation marks

I'm attempting to isert the following formula into a cell via VBA:

Please Login or Register  to view this content.

but given an error I'm guessing due to ' symbol being used in the formula. How can I avoid this?

Thank you

The problem is the double quotes. The workaround below uses the character code for them so that the compiler won't try to pair them up with the string delimiter quotes at the beginning and end.

Please Login or Register  to view this content.

Cool! Thank you. Now that I realize what the issue is, I was actually able to make it work by putting """" instead of "" - quadruple quotation marks in place of double.