![]() |
Automating Goalseek When moving points on a graph
I have created a macro that activates points on a graph so
I can move them to change the slope of the graph. After I move the points, the goalseek input box appears, and it requires me to enter the cell reference so it can change the value of that cell, then it finds a solution and asks if I want to keep the solution. I want the macro to automatically enter the cell reference and click 'ok' to keep the solution after I move the graph point. Is there a 'wait for user entry' command or something else I can use to do this? |
All times are GMT +1. The time now is 08:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com