Use SomeSheet.Name in Formulas

[Master_Sergius]

Hi:

I have the following lines of code (... - omitted lines):

Please Login or Register  to view this content.

I would like to change hardcoded sheet name 'Input' in Formula, so it should look like:

Please Login or Register  to view this content.

And I got error - 400. Did I make some mistake with quotes (")? Or how it should look like? Or it is possible to use codename here somehow?
I have to code this within MS Excel on Mac, so I don't know how to debug it here, it's a bit painful.

[Fluff13]

It should be like

Please Login or Register  to view this content.

[Master_Sergius]

It works, thanks! And I got the idea

[Fluff13]

You're welcome & thanks for the feedback