Find & Replace All Sheets Using VBA

Thanks in advance!

I need to find column a and replace with column B text across all sheets. The code I have is only doing the find and replace on one sheet? Any tips?

Please Login or Register  to view this content.

Correction on Code..

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thanks! That worked faster. However it is only finding and replacing in row A and row B across all sheets... I want it search entire worksheet for text shown in "row A" and replace any instance of it with the corresponding text in "row B" . I do not want it to match entire cell content.

Is that possible?

getting error.. Capture.PNG

Originally Posted by HSV

I have a file imitated, but no error to me.
Maybe you could upload your file so we can see where things go wrong.

Here ya go! And thanks again.

Originally Posted by HSV

Your length of your words may have a length to 255 characters.
Sheet 1 cell B6 has 461 characters.

Shortened it and it still is only replacing rows A & B only, its not finding instances of A in entire sheet and replacing all instances of A with B... lol. I've been trying to get this to work for 2 days.

Originally Posted by HSV

Replace by 'xlwhole' 'xlpart'

THANK YOU!!!!!!!!!!!!

I could give you hug!

-Tierra