https://issues.apache.org/ooo/show_bug.cgi?id=124723
--- Comment #3 from Jack Mathis <[email protected]> --- Comment on attachment 83243 --> https://issues.apache.org/ooo/attachment.cgi?id=83243 example of sheet with failing macro After I submitted the above issue, I tried fiddling with editing the macro to try and make it work, but without any luck. I just don't know enough about the macro language to fix it, and I haven't been able to find a good reference to the macro language yet. My feeling is that the basic problem is that the macro is missing something that should define what the variable called "Array()" is, and since the variable is undefined, nothing happens when the macro executes the goal seek command. I left a comment in the macro to that effect. To create the macro, I put the cursor on the cell B10, went up to the menu and selected "Tools > Macros > Record macro ". Then I selected "Tools > Goal seek", and entered the values of "0" in the goal value, and B2 in the changing cell value. (in other words, find the value of B2 that is necessary to force the value in B10 to go to zero. The system responded that it had found an appropriate value and asked me if I wanted to have it entered in cell B10. I said yes. I then moved the cursor one step to the right, using the arrow key. (That part of the macro works fine). I then hit the "Stop recording" button, and saved the macro that had been recorded as "Netbal". To test the macro, I set the value in B2 back to what it was before recording the macro, which is shown in the attached sheet. Then I went to "Tools > Macros > Run Macro" and selected "Netbal" which resides in Module1. The macro then runs, and the cursor jumps over to cell C10, but the value in B10 is not changed. Hope this helps, Jack -- You are receiving this mail because: You are the assignee for the issue. You are watching all issue changes.
