Goal seek with Rand values

[XxLl123]

Hi Folks.

I'm looking to randomize some of the inputs to a goal seek calculation that I can run multiple times for different random values. This creates the problem of goal seeking on continually generating random values which doesn't work. is there a way to freeze the random values functions during the goal seek?

any help appreciated.

 

[sadboy309]

What the "freeze the random"??? I don't understand what you means? If you want visible value random one time, so you just need close automatic calculation, or change it about manually calculate. You try!

 

[bobsan42]

set the Application.Calculation to xlCalculationManual or -4135.
You will have to copy the values before you turn it on back to xlCalculationAutomatic