Dynamic Find and Replace

Greetings all,

Is there a way in which you can use two cells (a2 & b2 for example) with a button to trigger a macro which will search for a2 and replace with b2 over a certain range of cells? unless there is a function to do it of course, which i would prefer!!

Ta muchly,
Ali Mac

Sure is; you have two simple options -

1. take a look at the Find function; this is directly out of the online help:

Please Login or Register  to view this content.

Obviously, you'd just make the "2" the value of A2 and "5" the value of B2 in your example.

2. use the Replace function:

Please Login or Register  to view this content.

Hope that helps.

Try this code

Please Login or Register  to view this content.

Note... First select the range where u want to find and replace and then run the macros..

Thanks Shijesh So Retro - the answer to your question is "yes"; just replace my "asdf" and "qwerty" with the range values as Shijesh has shown below.