Hi!
Value of range:
A1=1
A2=2
A3=4
A4=5
A5=7
A6=6
A7=3
I want to know if value of range A1:A7 is simultaneous? I mean if the value is 1,2,3,4,5,6,7.
In case above, cell A3 should be 3, and the macro must give a msg box "The cells are not in simultaneous".
Tanks for help.