View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] aidan.heritage@virgin.net is offline
external usenet poster
 
Posts: 244
Default Nested For..Next Qn.

apart from missing an END IF you have code that should work OK in terms
of resetting X

Stella wrote:
Is it possible to force a change to a parameter in nested loops?

In other words, I want to compare two cells in different rows and, depending
on the result, restart the loop counter from a different position.

e.g.:-

For x = 1 to 99
For y = x+1 to 100
If Cells(x,1) = Cells(y,1) Then
Cells(y,1) = Range("y,3")
x = 1
next y
next x

The compare could be true at , say , x= 3 and y = 30 but I need the test to
recommence at x= 1 to take into account the new value in Cells(y,1)

I've tried the above plus a few variations but without success


TIA
Stella