Write macro to bypass clipboard

I found a post on converting code from being dependent on the clipboard to being independent of the clipboard. It takes this code,

Please Login or Register  to view this content.

and converts it to this,

Please Login or Register  to view this content.

I get this code when I record a copy and paste macro.

Please Login or Register  to view this content.

The issue I am having is getting it to work with my use of relative refrences. This macro would be used multiple times, so it would insert the text into the next available column and I don't know how to do that. Any help would be appreciated.

Sorry, I forgot to mention that the sheet that I was selecting the R1:R19 range from is the calculator sheet.