• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to loop goal seek in continuous rows


New Member
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.