Formula trouble in VBA

Hi guys,

I'm getting a compile error before I even get a chance to use it. I'm sure it's simple but it's got me stumped.

Please Login or Register  to view this content.

I've underlined and made bold, the area where the error occurs.

The error is:

Compile error:
Expected: end of statement


Thanks for your time,

Ciaron

Wherever you use quotations within a string literally in VBA you must double up, eg:

Please Login or Register  to view this content.

As you can see in the syntax generally speaking " denotes either commencement / end of a string in VBA (hence the initial error)