Find & Replace

[rizmomin]

I Need a macro VB code to replace all occurance of "Apple" to "Oranges"
in a sheet Range A2 to E370


Please help...

Thank You

Riz Momin..

[Ron Coderre]

Perhaps a variation of this:

Please Login or Register  to view this content.

Note: that code will replace "Apple", but will not replace "Apples"

Is that something you can work with?
Post back if you have more questions.

[rizmomin]

Thank u for yout prompt help..
I just forgot to mention that this find and replace would in the Formula.

Example

Cell E2 have Fomula =Apple!E2 etc....

and similarly other cells...

I did run the test with the above code and it would not replace..

Riz

[Ron Coderre]

OK....then try this variation:

Please Login or Register  to view this content.

Does that help?

[rizmomin]

This works great...

Thank you very much for yoru help..

Riz