Replace text using with Sheets("").Range

[Hyflex]

Hey, I'm using the following code:

Please Login or Register  to view this content.

I'm trying to get something like below working...

Please Login or Register  to view this content.

Is there anyway to make that faster and make it remove them from a different sheet without having to switch sheet (I know ScreenUpdating would make it appear as if it didn't change page but... the macro would be useful with other macros that I have.

[Andrew-R]

How about something like:

Please Login or Register  to view this content.

[Hyflex]

Isn't that pretty much the same as:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[Andrew-R]

Yes, except it loops through all of the sheets in the workbook without switching sheets - isn't that what you're trying to do?