View original (French)

Limit Do ... Loop

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

2 answers

  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
    1. fiddy Contributor
      Hello,

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

      --

      Google is your friend