Find and replace all macro

[cmb80]

Hi there, Can someone give me the coding to find all words (for example apple) and repalce with "apples" in a worksheet of over 18,000 columns?

I know how to do this as a one off using ctrl + f, but need it in macro format

(recording a macro and then running the ctrl f part didn't seem to capture what i need).

[TMS]

Are there other words in the cell? Or do you want to match the whole cell content?

Recording a macro and tidying it up a little for readability gives:

Please Login or Register  to view this content.

But, if you can't match whole cells, you need to take into account that you might already have "apples" or, possibly, "applecake" ... or whatever.


Regards

[cmb80]

Hi, I may have actually not given the full story.

i first need to apply a filter using the header rows. So any item in column K that is "yes" and that has apple in column C or D needs to be changed from apple to apples.

That means any items in column C or D that have NO in column K stay as apple and aren't changed.

The match is excat - apple to apples

[TMS]

After you filter on column K, use:

Please Login or Register  to view this content.

Regards