Goal seek - column reference - user input message

A

al

What would be the code if i want to have a user input message box to
ask for column Y in macro below - thxs

Sub Goalseek()
'

Range("Y84").Goalseek Goal:=Range("AL84"), ChangingCell:=Range("Y50")

Range("Y85").Goalseek Goal:=Range("AL85"), ChangingCell:=Range("Y51")

Range("Y86").Goalseek Goal:=Range("AL86"), ChangingCell:=Range("Y52")
End Sub
 

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
Loop several sheets - part 3 - Dave Peterson - Goal seek 4
Loop several sheets - part 4 - Dave Peterson - Goal seek 1
Do Loop Goal Seek won't End Sub 2
Goal Seek with dynamic Goal Seek 1
vba goal seek in 07 envoking sumcolor UDF 0
vba goal seek 2 1
Using Goal Seek without a macro 1

Top