Does goal seek work when macros run with every worksheet update

spurs

Active Member
Joined
Oct 18, 2006
Messages
479
Office Version
  1. 2016
  2. 2013
  3. 2010
  4. 2007
  5. 2003 or older
Platform
  1. Windows
I have a macro that runs with every entry in a worksheet named "A".

When I write macros that reads and writes data to and from worksheets, I typically create a dummy worksheet where the data is stored simply to avoid formatting changes in the main worksheet from affecting the macro.

Therefore, Worksheet "B" takes the results of cell D25 from worksheet "A" and just copes that result into its cell A2 for easier locating of data.

The macro takes this information from the worksheet "B" , does some calculations and then writes some results into other cells in Worksheet B. One of the cells of interest is B11 in worksheet "B".

Worksheet "A" looks to worksheet "B" and directly copies the result of B11 into Worksheet "A" D45.

Doing entries into worksheet A gives correct results in D45.

My problem is:

I cannot get goal seek to work to calculate Worksheet A cell D45 based on changes to A2.

The goal seek starts but gets lost and eventually the system crashes.

Are there any clues as to why this would not work? The macro has about 300 lines and reads about 10 pieces of data in total and writes about 20 pieces. But the calculation between result for D45 depends entirely on A2 with all other variables remaining constant

Any thoughts?
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Forum statistics

Threads
1,223,911
Messages
6,175,327
Members
452,635
Latest member
laura12345

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top