I want to check a range for available serial numbers.

The numbers run from 1001 and up, but as the cases close, some migh
become available again.

E.g. 1004 could be deleted from the range (becoming available again
while 1005 and so on is still taken...

How do I check the range "case" for lowest available number starting a
1001, and return it as an integer?

Thank

--
Message posted from http://www.ExcelForum.com