VBA AutoFilter issue

Hi All

I am new to excelforum, and also fairly new to VBA.
most of my experience consists of recording macro's and reviewing the code and amending as required.

i have an issue with a macro I am creating at the moment. The part of the code in question will (eventually) filter a tab of data and copy and paste the result onto another tab.

Background - Each row of data is categorised into - Standard Approve, Standard Reject, Review or Exception. Lines that have not yet been categorised return #na (from a vlookup).

After allocating the exceptions, I need the macro to re-filter to show all remaining lines excluding #NA.
The issue I have is that, not all other categories will always have any existing lines (usually standard reject).

The filter code i have is this:
ActiveSheet.Range("$A$1:$S$6421").AutoFilter Field:=15, Criteria1:=Array("REVIEW", "STANDARD APPROVE", "STANDARD REJECT")

This was done by recording me unticking the #na box in autofilter.
Is there a way I can filter by categories, but only if they exist?

E.G if Standard Reject contains 0 lines, ignore the filter command and continue to filter by only Review and Standard Approve?

Any assistence would be greatly appreciated

Hi

I read your response and really hoped it would be that easy. Unfortunately "<>#NA" does not affect the autofilter. The data remains unfiltered.

Apologies. Works like a dream. Thanks a lot!