Return the absolute cell reference location of cursor

[ad5184]

I want to move the cursor to 2 specific locations on the sheet using visual basic (which I can do). Then I want to use the first location of the cursor as the cell to goalseek on, and the second location as the cell to change for the goal seek (i.e. the first location would be A1 in the code below, and the second location would be AF35).

Range("A1").Select
Range("A1").GoalSeek Goal:=0, ChangingCell:=Sheets("2"). _
Range("AF35")

It needs to be in this order as the input cells will be found from a list from user input to inputbox()

 

[tactps]

I am not exactly sure what the issue/problem is. Can you please explain where you are having trouble?

Is it:
Getting the goalseek value?
Attaching it to an input box?