I used random number coding to total a range up to 30 random numbers (MyFill Sub), now I need the sum of that range to equal a real number that I input. How can this be done?
I used random number coding to total a range up to 30 random numbers (MyFill Sub), now I need the sum of that range to equal a real number that I input. How can this be done?
Welcome to the forum
If I understand the context of your question, you could look at using Excel's Solver Add-in
Solver can update the result of a formula to match a specific value but changing the values of the precedent cells of that formula.
Solver is an add-in that you can activate in Excel. It will then display on the DATA ribbon.
Regards,
Rudi
Rudi, thanks so much for the help! I have been out of contact due to VA appts and memorial services for friends and such. your solution worked remarkably well and thanks again.
When I run my code MyFillRange I have to manually press Alt+F11. Is there a way to add a line of code to make the results show automatically?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks