Hi there
I have an equation that requires iterative calcualtion to get the desired value. what I have done is to rearrange the equation to put all the parameters on one side, and set the equation equal to zero, and use "goal seek" function to solve for the desired parameter.
Because I have to do the same thing for about 100 rows, I recorded the process in the macro, and the code looks like as below:
Range("$F$4").GoalSeek Goal:=0, ChangingCell:=Range("$D$4")
Then I copied the above function 100 time and changed the cell reference manually in the macro for the rest of the spreadsheet. This works fine, However, when I insert rows in the spreadsheet, I have to manually update the macro as well, which is very frustrating.
Can anyone help me to fully automate the process, so that it is still able to do iterative calculations once I insert a new row.
Thank you
<!-- / message -->
I have an equation that requires iterative calcualtion to get the desired value. what I have done is to rearrange the equation to put all the parameters on one side, and set the equation equal to zero, and use "goal seek" function to solve for the desired parameter.
Because I have to do the same thing for about 100 rows, I recorded the process in the macro, and the code looks like as below:
Range("$F$4").GoalSeek Goal:=0, ChangingCell:=Range("$D$4")
Then I copied the above function 100 time and changed the cell reference manually in the macro for the rest of the spreadsheet. This works fine, However, when I insert rows in the spreadsheet, I have to manually update the macro as well, which is very frustrating.
Can anyone help me to fully automate the process, so that it is still able to do iterative calculations once I insert a new row.
Thank you
<!-- / message -->
