# Thread: Cicling FOR NEXT (2000 sr -1)

1. ## Cicling FOR NEXT (2000 sr -1)

I have the this for next routine work with sheet GRUPPO it cicling each value from column A to all in column J....
now i want to cicling each value in column A of sheet GRUPPO and each value in line 2 of sheet STAT_L0953 but only if in line 1 of sheet STAT_L0953 the value is >0...
Example:
first value in column A of GRUPPO is 4500 cicling this value for each value in line 2 of STAT_L0953 in this case first block of cicling is D to S skip T and U because the value in line 1 is 0... goto next V because the value is >0... ecc...
..............
For SPORT = 2 To Worksheets("GRUPPO").Range("L1").Value
SPORTELLO = Worksheets("GRUPPO").Range("A" & SPORT).Value

For SOSP = 2 To Worksheets("GRUPPO").Range("K1").Value
SOSPESO = Worksheets("GRUPPO").Range("J" & SOSP).Value

Next SOSP
Next SPORT
....................

2. ## Re: Cicling FOR NEXT (2000 sr -1)

I don't have the slightest idea what you're asking.

3. ## Re: Cicling FOR NEXT (2000 sr -1)

In effect instaed to cicling each SPORT (column A of sheet GRUPPO) with all SOSPESO (column J of sheet GRUPPO) i want to cicling each SPORT (column A of sheet GRUPPO) with all SOSPESO (range D2 to EH2 in sheet STAT_L0953)...
Example:
4500 to D2, E2, F2....EH2 with this condition:
exclude from this cicling each cell in D2 to E2 if in line 1 of STAT_L0953 is present a vlue >0....
in this case the first cell in STAT_L0953 is T2 because the summ in T1 is 0, next U2 because the summ in U1 is 0, next AB2....

4. ## Re: Cicling FOR NEXT (2000 sr -1)

Don't you mean <>0 instead of >0? If you really mean >0, D2 would be the first cell to process since D1 is not >0.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•