HYPERLINK function without filename

I am trying to insert a hyperlink that refers to a cell in a different sheet of the same workbook using the =HYPERLINK function.

I can get it to work with a formula like:

Please Login or Register  to view this content.

However when I remove the filename so the formula looks like

Please Login or Register  to view this content.

I get a "cannot open specified file error"

I really don't want to include the filename -- what if it changes?

Is there any way to do this (other than using =CELL("filename"))?

I also don't want to use the "Insert > Hyperlink" menu command, because I will eventually want to use a formula to create the address for the link.

Thanks. In brief, I needed to add a hash sign to the reference:

Please Login or Register  to view this content.