Hello All

I've created some code that looks through a range of nos. & then
displays a list of free nos. I've set the range up using validation as
below:
Case "Cardiff":
Range("C1") = "20000"
Range("D1") = "23499"

My problem is that the search looks for missing nos between these
ranges & if no. 20000 is free nothing is returned. What I'm wanting to
do is to add = option to the case but unsure how to do this.

Hope someone can help
Thanks


--
robmeister
------------------------------------------------------------------------
robmeister's Profile: http://www.excelforum.com/member.php...o&userid=24364
View this thread: http://www.excelforum.com/showthread...hreadid=380194