Hi,

I have the code below which allows me to update the links in formulas in a worksheet I have. There is technically nothing wrong with the code, but I run into a problem during the part of the "Update Source process" that brings up the box to select the worksheet to update the link to. Because the sheet I want to update links to has a different name than what the formulas currently reference, it prompts me to select the sheet, as expected. The issue is that I have over a hundred formulas that need to be updated, and excel makes me click the desired sheet for each cell containing the formula to be updated. Is there a way that I can select the sheet of the desired file once and use that selection for each subsequent link update?

Secondly, and this is not as big of an issue, I have the macro prompting the user to select the desired file twice (the first time to paste the file path on a sheet, and the second time when updating the links). I intend that every time, both selections should be the same, so is there a way I can consolidate those two parts of the code?


Please Login or Register  to view this content.