New to VBA! Goal seek macro with a variable cell reference

[MichaelS94]

Hi,

I'm trying to write a relatively basic macro to run a goal seek function:

Range(G24).GoalSeek Goal:=0, ChangingCell:=Range("E17")



The only complexity is that I would like the "G24" to be variable.

So the row which the range() of the goal seek references (row 24 in this case) should be 20 rows below Cell E14 (which has a value of 4 in this case). Hence the G24.

Basically I want to be able to adjust E14 from say 4 to 10, and have the goal seek macro use G30 instead of G24.

Is this possible?

Thanks!!