Active Cell in VBA

Hi all,

I just started to use VBA and I am a bit lost. I need to get the coordinates of the active cell to be entered somewhere in my spread sheet.

I wrote that:

Please Login or Register  to view this content.

and it changes the name of the spread sheet for the active cell one (e.g.: $A$1), so it's kinda working...

I've been trying and looking everywhere to find how get the active cell's name to be put in the file and not as the spread sheet's name but I am very struggling...

Any help will be very appreciated
Thank you!!