goal seek reference

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
I forgot to say that the goal seek should be performed by changing the hard
coded value in cell af 13
 
Sub TEST()
Range("af21").GoalSeek Goal:=Range("ac21"), ChangingCell:=Range("af13")
End Sub

ah ha!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Goal seek - column reference 3
IF question 4
Iserror help 3
Do Loop Goal Seek won't End Sub 2
macro Help 3
Goal Seek Advice 2
Goal Seek with dynamic Goal Seek 1
Correcting "Circular Action" in Worksheet_Change 2

Back
Top