View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Check a cell for duplicates.

Hi
see: http://www.cpearson.com/excel/NoDupEntry.htm

--
Regards
Frank Kabel
Frankfurt, Germany


With your help I have now managed to produce a really useful
spreadsheet but I am being driven nuts by my inability to finish the
final part!

Along with a bunch of other stuff my code creates a random number.

I have managed to find the next available cell in column A on a given
spreadsheet and place the number there.

What I want to do before entering the number is check that it doesn't
already exist somewhere in that column. If it is already present I
want to loop until a unique one is found.

I have no doubt that this is really easy but I am just too dumb.....!

Thanks for your help.


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