Using Named ranges in VBA

I am trying to add a string to a named range's Refersto value. The issue is that the string has to being with a "=" to be used with another internal tool. I can create the string easily, but i get the error attached when I try to add the reference. Is there any way to override the error, and place the string having a "=" at the start of the string. A VERY simplified mocked up example is below:

Please Login or Register  to view this content.

Any help to make this work would be great as I can't change the other end of the process, I need to shoehorn this to work. I know its possible beacuse its done elsewhere, but the guy who wrote the code is no longer around and I can't ask him...I am kinda SOL

12-22-2016 11-28-34 AM.png

I actually had to make a correction. To get the quotation marks I need, I changed it to this:

Please Login or Register  to view this content.

tested it and still get the same error.