Loop needed to edit links based on data in cells

Hi, I have been scouring the internet trying to find a solution to this so any help would be appreciated.

I have a workbook (wbCP) which pulls data from several different workbooks. I have written some code that updates a few selected links with data pulled form a separate workbook (wb).

In workbook (wb), all the old links are listed in Column B, from Cell 2 downwards for x number of occasions, depending on how many links need updating. At the same time, all the new links are listed in Column A from cell 2 downwards.

I have managed to get the code to update the relevant links from Cell B2 to A2, but I don't know to loop it so that it then progresses to finding the link in B3 and updating it to the link in A3 and so on and so forth...... until the end of the dynamic range is reached.

Any help is greatly appreciated.

Code is below:

Please Login or Register  to view this content.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)