Macro to find missing numbers?

[silentwolf]

Hi guys,
was wondering if someone knows a macro to find missing numbers in a column?
I in column A numbers from 1001 to 1400 and there are some missing for example 1001 next is 1005 then 1105 and the next number is 1108.
So that I dont need to look through all numbers and compare them I would like to find the numbers what are missing.
And perhaps either show them to me in a message box or copy them in Column D.
I am sure it is possible but I just don t know how.
Would be very kind of you if you could help me with this question.

Many thanks!
Albert

 

[silentwolf]

Sorry guys I thought of a different way of searching for my problem and found this solution.

Say you have the numbers 2, 4 and 6 in the range A1:A3.  You want to  know
which numbers from 1 to 10 are missing.

-Enter the numbers 1 to 10 (use the Fill handle) in C1:C10.
-Enter the formula:

=IF(ISERROR(MATCH(C1,$A$1:$A$3,FALSE)),"x","")

in D1 and copy it down to D10.  Now every "x" represents a missing  number.

Sorry that I was not finding it before and did asked.