Norman Jones Wrote:
Hi Shirley,

Assume tha the #N/A values are in column A, then try:

'===================
Public Sub TestA()
On Error Resume Next 'In case no error values found!
Columns("A").SpecialCells(xlFormulas, xlErrors).EntireRow.Delete
On Error GoTo 0
End Sub
'<<===================

Change A to suit.

---
Regards,
Norman



"Shirley Munro

wrote in message
news:Shirley.Munro.1uw02h_1125925526.0297@excelfor um-nospam.com...

Hi

I am recording a Macro which uses a VLookup to fill in values i
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 delet
these
rows. The problem is that the orginal file is downloaded on
regular
basis and the number of rows varies and therefore the number o
#N/A's.
Is there macro code which will automatically delete all row
containing
#N/A's.

Thanks

Shirley


--
Shirley Munro

------------------------------------------------------------------------
Shirley Munro's Profile:
http://www.excelforum.com/member.php...nfo&userid=836
View this thread
http://www.excelforum.com/showthread...hreadid=401910


Nice work - specialcells! Though quite specific and hard to generalis

--
gearo
-----------------------------------------------------------------------
gearoi's Profile: http://www.excelforum.com/member.php...fo&userid=2657
View this thread: http://www.excelforum.com/showthread.php?threadid=40191