Code puts title in first row, want it in every row

Hey everyone,
I'm trying to figure out why I keep getting a syntax error when coding out this part.
I have made it so it returns the output in a specific row, however I would like it to return the output and put it in multiple rows.
My code so far is

Please Login or Register  to view this content.

I'm fairly new to VBA coding and just need a little direction as to how to resolve the problem.
Cheers

Administrative Note:

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here. I am, therefore, closing this thread, but you may continue here in the original thread …