I would like to find and replace numbers or text in formulas. I have a macro assigned to a symbol which, when I press it, presents a pop-up screen.
For example in the worksheet "Datasheet1" there are a lot of formulas that have the cell K200 in them. I would like to change them to K300 by using the pop-up screen.
I've come across the formula below, but it doesn't work unfortunately.
Presenting a worksheet is kind of difficult because of the specifics.
Please Login or Register to view this content.