Results 1 to 4 of 4
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Cicling FOR NEXT (2000 sr -1)

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

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    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
  •