missing numberscode snippet

[var]

Could some help me with code that finds missing numbers between 1 and 100 in the in the range of A1:A200.

and show missing numbers on screen.

I did see few scripts looks very complicated and some did not run.

thnsks
var

[Olly]

Try this:

Please Login or Register  to view this content.

not really clear what you want to do with the missing numbers, but this puts them into an array, then displays the full array in a msgbox.

[haripopuri]

Please Login or Register  to view this content.

[var]

kool..perfect..thats what exactly i wanted olly

thanks to you to haripopuri