i dont see DOTS within the With/End With construct..

Keepitcool, there are dots there. The functions works as long as th
criteria is within the quotes or as a variable. The problem comes whe
trying to set it to look for both the variable 'usid' an
"EQSERVICEMAC

--
Michael Wis
-----------------------------------------------------------------------
Michael Wise's Profile: http://www.excelforum.com/member.php...nfo&userid=699
View this thread: http://www.excelforum.com/showthread.php?threadid=26236