Many thanks to you both.
Regards.
"Dick Kusleika" wrote in message
...
Stuart
:
a) that all entries are filled
You just cycle through all the entries and test the len of column two to
be
greater than zero.
b) that all values are valid
Maybe try to insert the sheet into the existing workbook and rename it.
Use
error checking to see if you get an error, and which error you get. If
you
don't get an error, delete the "temporary" sheet.
c) that all entries are unique
You could put all the names in a collection with their name as the key
value, then compare Collection.Count to the number you should have.
--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
http://www.grisoft.com).
Version: 6.0.515 / Virus Database: 313 - Release Date: 01/09/2003