Hi

I am recording a Macro which uses a VLookup to fill in values in colum
A from another file. Where a match is not found it displays #N/A.
can use AutoFilter to filter out all the #N/A's and then delete thes
rows. The problem is that the orginal file is downloaded on a regula
basis and the number of rows varies and therefore the number of #N/A's
Is there macro code which will automatically delete all rows containin
#N/A's.

Thanks

Shirle

--
Shirley Munr
-----------------------------------------------------------------------
Shirley Munro's Profile: http://www.excelforum.com/member.php...info&userid=83
View this thread: http://www.excelforum.com/showthread.php?threadid=40191