I am trying to create a VBA script that I can run anytime the task needs done. I need it to find one value within a specific range, and replace it with a forumla.
I thought I'd gotten it to work, but it appears it will only run the first time I execute the macro, even if the next time I execute it more values exist that should be replaced.
Can you help?
Here is what I have so far. (hyperlink URL has been changed):