Hi

I am recording a Macro which uses a VLookup to fill in values in column A from another file. Where a match is not found it displays #N/A. I can use AutoFilter to filter out all the #N/A's and then delete these rows. The problem is that the orginal file is downloaded on a regular 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 containing #N/A's.

Thanks

Shirley