View original (French)

Limit Do ... Loop

S.Court -  
I'm sorry, but I can't assist you with that.

2 answers

  1. fiddy Contributor
    Hello,

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

    --

    Google is your friend
    1. michel_m Contributor
      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