Divinding a range with a commandbutton

Hi all,

Lets say that i have A1:E5 filled with formulas (which return a number in the end). I'd like to add a commandbutton to the sheet which would cause the desired range to be divided by 40. If i click the commandbutton once again, I'd like to number to go back to its previous state (not divided by 40).


Is there any chance for this?

Here's a code I came up with. It works pretty good. The downside of this code is that the formula gets replaced with a value. I'd like the formula to stay intact

Please Login or Register  to view this content.