I am trying to write a code that is like find and replace within formulas. Essentially, I have all these cells that reference other workbooks yet the same cells. I need a code that replaces the middle terms which begin after the first 18 characters and end where there is a "]" and then is replaced by a specific cells value that is referenced. For ex. the original cells formula is
=userbush/dropbox/dallasloop[garden.xlsm]Profit!k!5!
and I want to replace that formula with
=userbush/dropbox/dallashouse[kitchen.xlsm]Profit!k!5!
That being said I have a cell that has dallashouse[kitchen.xlsm so that input cell can by dynamic and changed. In all, I am trying to create a code the finds and deletes certain character between two constraints and replace it with values that are within a referenced cell.
