If the range is extremely large, =countif() can be slow.

if isnumber(application.match(yourvaluehere, yourrangehere,0)) then
'it's already there
else
'do the add
end if



Dave Peterson wrote:

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

--

Dave Peterson