Find and replace macro

Please see the attachement it will be very clear

Please Login or Register  to view this content.

Good day,

Thanks for your macro and your effort that u put..


But i have one small issue with this macor, i find Range("A2").Value, it works only for the coloum 'A2", i need it for more than "A200", please clear this issue. Then it will be really help full for me,,

@ superking.
I think you could put some more effort into supplying a representative workbook,
Just one single row does nor really tell us anything. Also there is nothing in sheet2.
If you expect the people who are willing to help you to do all the work for you you are out of luck I think.
Attach a workbook with before and after and at least 10 to 20 lines.
I don't think that that is too much to ask, is it?

Bit sleepy at the moment, but this may do the job.
It checks all rows from row2 in sheet1

Please Login or Register  to view this content.

Good day,

@ G e r a r d

Thaks for your great help.. really u solved my problem.. it works very well.. Thanks for your effort. you really rocks.....

Your welcome.
Don't forget to mark the thread solved
Click the little star * below, to give some Rep if you think an answer deserves it.