find and replace based on a column in another sheet
Posted by harold on November 21, 2001 8:56 PM
hello again! how do i make a VBA code to run find and replace function on an activesheet based on data written on another sheet. Example in sheet "find&replace", column A has all the data to find while column B has the corresponding data as replacement. The VBA has to check if the last row on column A is reached then stops executing. I want to run it say on "Sheet1". How do I do that? It's advantage is I dont have to edit the VBA code every once in a while and re-type all the new things to find and their corresponding replacement. With this set-up, all I have to do is open the "find&replace" sheet and add, edit, delete or what not. Thanks a million!!!!!