Declare it as a Long Steve.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"STEVEB" wrote in
message ...

Hi Bob,

Thanks for your help, I appreciate it!

I could not get the code to work. the problem is at:

If ans 0 Then

I am getting this error message:

Run-time error '13':
Type mismatch

Is it because I am using dates?

I have about 20 dates on Sheet 1 Range B2-B50.
On Sheet 2 in Column A I have about 175 dates (1 in each row)
I would like to delete the entire row of data if any date in column A
Sheet 2 matches any of the dates in the range B2-B50 on Sheet 1.

Thanks again for your help.


--
STEVEB
------------------------------------------------------------------------
STEVEB's Profile:
http://www.excelforum.com/member.php...fo&userid=1872
View this thread: http://www.excelforum.com/showthread...hreadid=390607