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
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