I have a column with numeric values and #N/A. I am trying to filter for everything except the #N/A and then delete. The following is what I have so far, but it's not working.
Any help is appreciated. Thanks!With ActiveSheet .AutoFilterMode = False .Range("$A$1:$V$1").AutoFilter .Range("$A$1:$V$1").AutoFilter Field:=5, Criteria1:=Array( _ "<>#N/A", "="), Operator:=xlFilterValues End With Range("E2:E" & LR).SpecialCells(xlCellTypeVisible).Select Selection.Delete Shift:=xlUp
Bookmarks