Find And Replace Using Offset Function

hi,

Please Login or Register  to view this content.

i want to find data in activecell and replace with (NEXT COLUMN TO ACTIVECELL) activecell.offset(0,1).value

Take a look at this file and see if it is doing what you want.

The value in B3 will be what it is looking for (to replace) in the active cell.

So set what you want to replace for the active cell in B3, select the cell you want to replace text in, then hit the replace button.