Hi Ken , long time no speak!
Whilst I agree with Ranman256 about using a cell to contain constants that may change , I don't no why you cannot use the find and replace function. I wondered if I was going senile but tried it and it works ,just changes the 1000 to 10000 in each formula.
Brian
I...