I am trying to create a simple macro that runs a Goal Seek, but also displays an input box to allow the user to enter the proposed value.
myNum = Application.InputBox("Enter a number")
ActiveCell.GoalSeek Goal:=myNum, ChangingCell:=ActiveCell.Offset(-2, 0). _
The only result I get is that the reference is not valid.
I know I am probably way off mark but can anyone help?