VBA goal-seek

[Jeff12]

I have a named range called Periods which = 45 and i want this cell to change the range below. How do I change Range.("N45") to pick up column N but pick up the name range Periods which will be changed by the user?

Sub Macro1()
'
' Macro1
'
'
Sheets("Cashflow").Range("N45").GoalSeek Goal:=0, ChangingCell:=Range("G8")
End Sub

thanks Jeff

 

[Andrew Poulsom]

Maybe try:

Sheets("Cashflow").Range("N" & Range("Periods").Value).GoalSeek Goal:=0, ChangingCell:=Range("G8")

 

[Jeff12]

thanks a lot,
what if I wanted to add the value 5 to the periods range?

 

[Andrew Poulsom]

Try:

Sheets("Cashflow").Range("N" & (Range("Periods").Value + 5)).GoalSeek Goal:=0, ChangingCell:=Range("G8")