search for absense of data
 

Thanks Dave, That works perfect! Thanks for the introduction to "InStr
An obviously good tool to have in the box!

thanks again
:

--
Hammer_75
-----------------------------------------------------------------------
Hammer_757's Profile: http://www.excelforum.com/member.php...nfo&userid=741
View this thread: http://www.excelforum.com/showthread.php?threadid=31399