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