Hello Jon,
Use the CountIf worksheet function. If the result is 0 then add th
name.
Example:
N = Excel.WorksheetFunction.CountIf(Range("A1:A50"), "Jon")
N will equal the number of times the name Jon is found in the range o
A1 to A50.
Sincerely,
Leith Ros
--
Leith Ros
-----------------------------------------------------------------------
Leith Ross's Profile:
http://www.excelforum.com/member.php...fo&userid=1846
View this thread:
http://www.excelforum.com/showthread.php?threadid=37808