Hi
I am trying to do a loop of a named range while comparing to the same indexed value of a different named range i.e compare the first cell in one range to the first cell in a different range and then move to the next one in both.
However i dont know how to move to the next cell in the range that I am comparing the looped range with. I am using
Set j = Range("Start")
For Each c In Range("End").Cells
s = j.Row
e = c.Row
Next c
And i need a line in there to move to the next j. Any help?
I am trying to do a loop of a named range while comparing to the same indexed value of a different named range i.e compare the first cell in one range to the first cell in a different range and then move to the next one in both.
However i dont know how to move to the next cell in the range that I am comparing the looped range with. I am using
Set j = Range("Start")
For Each c In Range("End").Cells
s = j.Row
e = c.Row
Next c
And i need a line in there to move to the next j. Any help?