This macro currently searches for the text in sheet 3, A1 in the whole of sheet 1 and then replaces it with the text from sheet 3, B1:
Is it possible to make this loop through all the pairs of the cells in the A and B columns in sheet 3 until it hits an empty cell? I've tried implementing the loop, but it doesn't seem to work, and it doesn't work when I simply swap the Range("A1") refs for Cells(1,1) type refs as well.Please Login or Register to view this content.
Bookmarks