Help with setting Column Range to remove string with VBA

Greetings all, I'm having an issue with the following code. Based on the debug, it's an issue with the Set Range line but I'm not sure what I'm doing wrong.

Thanks in advance for the assistance!!!

Please Login or Register  to view this content.

Mate,
Range.Column would return a column number, not a Range; so delete the .columns(1) part in your set statement. Simple enter the range of which you would like to perform this word check/replacement.
It should work fine.

Hi Jewelsharma,

Thanks for the prompt response.

I deleted as you said and I still get prompted for a debug with the following line highlighted.

Please Login or Register  to view this content.

Any thoughts?

Thanks sktneer!
Sorry I missed that.

Hi isritter,
as "Range" is a keyword in VBA code, it cannot be used to name a variable. So "Dim Range as Range" is an incorrect declaration. Make the changes as advised by sktneer and your code should work just fine.

Cheers!

jewelsharma and sktneer, thanks a million. Your wisdom has assisted me greatly!