#Name? error when using VBA to put a formula in a cell

Hello

I am trying to use VBA to place a formula in a cell, but I keep getting a #Name? error.

I know why the error occurs. When the formula is placed in the cell by the code it looks like

Please Login or Register  to view this content.

when it should look like

Please Login or Register  to view this content.

How do I stop the formula from ending up with the apostrophes around the cell reference.

This is the entire piece of code

Please Login or Register  to view this content.

Thank you

Stop looking. I worked it out. I changed

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

and that did the trick.

Thanks

@ ozhunter

Based on your last post it seems that you solved your problem on your own but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.