VBA to selct range before running macro

Need a way to ask the user what range they need the Find and Replace to execute on.
The range will vary based on type of report
I'm fairly certain that

Please Login or Register  to view this content.

needs to change to

Please Login or Register  to view this content.

But how can I add the select range?
Thanks

Please Login or Register  to view this content.

I'm at a loss with your
Then use the variable rng in your code
Can you help me out with where to place

Please Login or Register  to view this content.

Or if you want to select a range with your mouse.

Please Login or Register  to view this content.

Thank you for this additional input.