I wrote a macro to do a number of manipulations on a worksheet that ultimately produces charts. All steps of the macro work fine except for the final step, which is to click on a filter and deselect "#NA" (this step is crucial for the charts to display correctly). Can anyone help?

The macro debugger shows the following:

ActiveSheet.Range("$A$141:$L$153").AutoFilter Field:=2, Operator:= _
xlFilterValues, Criteria2:=Array(0, "4/1/2012", 0, "1/0/1900")

Partial table data (I want the macro to go to the filter and deselect #NA):

Date1 Date2 Perform Confidence
#N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A
Jan-12 #N/A 2.6 1.8
Feb-12 Jan-12 2.6 2.2
Mar-12 Feb-12 2.0 1.5
Apr-12 Mar-12 1.3 1.0
May-12 Apr-12 1.1 1.0
Jun-12 May-12 1.1 1.8
Jan-00 Jan-00 #DIV/0! #DIV/0!


The macro debugger shows the following:

ActiveSheet.Range("$A$141:$L$153").AutoFilter Field:=2, Operator:= _
xlFilterValues, Criteria2:=Array(0, "4/1/2012", 0, "1/0/1900")