goal seek reference
 

cell AC21 = 4.5 (hard coded number).

Cell AF21 = formula

Anyone have a macro that will goalseek cell af21 so it = cell ac21?

thanks a lot

goal seek reference
 

I forgot to say that the goal seek should be performed by changing the hard
coded value in cell af 13



"SteveC" wrote:

cell AC21 = 4.5 (hard coded number).

Cell AF21 = formula

Anyone have a macro that will goalseek cell af21 so it = cell ac21?

thanks a lot

goal seek reference
 

Sub TEST()
Range("af21").GoalSeek Goal:=Range("ac21"), ChangingCell:=Range("af13")
End Sub

ah ha!

"SteveC" wrote:

I forgot to say that the goal seek should be performed by changing the hard
coded value in cell af 13



"SteveC" wrote:

cell AC21 = 4.5 (hard coded number).

Cell AF21 = formula

Anyone have a macro that will goalseek cell af21 so it = cell ac21?

thanks a lot