VBA to use User selected range to find and replace

Hi All,

Coming up short on my code here.

I'm trying to do a massive find and replace across several columns and worksheets. I want to be able to select the range, then run the macro, and have it replace my designated items.

My first problem is having VBA recognize my pre-selected range on the active sheet.

My second problem is I'm not certain my replace code is correct.

Could anyone help with figuring out this code?

An example of what I've tried (with the exception that there are many more replacements):

Please Login or Register  to view this content.

Thanks!
-LM