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.
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.
Please Login or Register to view this content.
Last edited by HSV; 05-28-2012 at 05:45 AM. Reason: Edit the wrong code
Kind regards, Harry.
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?
Please Login or Register to view this content.
Last edited by HSV; 05-28-2012 at 05:42 AM.
getting error.. Capture.PNG
I have a file imitated, but no error to me.
Maybe you could upload your file so we can see where things go wrong.
Your length of your words may have a length to 255 characters.
Sheet 1 cell B6 has 461 characters.
Replace by 'xlwhole' 'xlpart'
You’re welcome,
Make sure columns B not blank cells in it.
Otherwise columns A will be a blank cell to.
Change the code to overcome.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks