Hi all,
That has to be dead simple but I can figure it out (a beginner!).
I have three rows: 5, 12 and 19. my columns run from L to BM for all three lines. What I need is a loop that does this:
Range("L5").GoalSeek Goal:=Range("L12").Value, ChangingCell:=Range("L19")
.... but for the corresponding cells in all columns. In a sequence, so column L, then, M, N, etc. Any ideas?
Many thanks for the help!!
That has to be dead simple but I can figure it out (a beginner!).
I have three rows: 5, 12 and 19. my columns run from L to BM for all three lines. What I need is a loop that does this:
Range("L5").GoalSeek Goal:=Range("L12").Value, ChangingCell:=Range("L19")
.... but for the corresponding cells in all columns. In a sequence, so column L, then, M, N, etc. Any ideas?
Many thanks for the help!!