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