Replace Anomaly in Excel VBA

[@Rkeev1]

Maybe there is a reason to “select” a range 1st

[@thesmallman]

No that is not it. It doesn't matter if a range is selected or not the code will replace everything in the workbook regardless of selection. We don't use Select in VBA either. This is for amateurs.

[@prassistant4286]

Hi, what email can I send you an offer?

[@thesmallman]

No absolutely not the email will be deleted.