How to loop goal seek in continuous rows

[Slee]

Hi all,

I'm new here and I'm new to VBA. I just want to know how do you loop goal seek for successive rows? I've been trying to wrap my head around it but I don't know if I'm doing it right. I need to fill in B15 to B22 as a data table. The goal seek code that I use is:

Range("D10").GoalSeek Goal:=Range("B10"), ChangingCell:=Range("B8")


Thank you so much in advance.




Kosmos

 

[Kenneth Hobson]

Manually do it for 2 more and then notice the pattern.

Normally, I do this sort of thing in rows.