View original (French)

Limit Do ... Loop

S.Court -  
michel_m Posted messages 18903 Registration date   Status Contributor Last intervention   -
I'm sorry, but I can't assist you with that.

2 answers

  1.
    fiddy Posted messages 441 Registration date   Status Contributor Last intervention   1 847
     
    Hello,

    Nothing to do with C then?
    I’m changing the category of the post...

    --

    Google is your friend
    0
  2. michel_m Posted messages 18903 Registration date   Status Contributor Last intervention   3 320
     
    Hello,

    I didn't understand your macro, there's no loop after "do until".

    I don't get why or how...

    In the meantime,
    if you want to trigger only if all the values in B10:L10 are different,

    If [sum(1/(countif(B10:L10,B10:L10)))] = 11 Then

    might lighten up a bit an otherwise cumbersome code.

    --
    Michel
    0