Before you add the record, check to see if it's in that range:

if application.countif(yourrangehere, yourvaluehere) 0 then
'it's already in that range
else
'do the add!
end if



bach wrote:

I have used the one for creating a user form contextures thanks.

I need to check that the Id given to a member is unique and not
currently on the database How would I go about checking this ?

--
bach
------------------------------------------------------------------------
bach's Profile: http://www.excelforum.com/member.php...o&userid=26134
View this thread: http://www.excelforum.com/showthread...hreadid=468520

--

Dave Peterson