spurs
Active Member
- Joined
- Oct 18, 2006
- Messages
- 479
- Office Version
- 2016
- 2013
- 2010
- 2007
- 2003 or older
- Platform
- 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?
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?