How to filter out #N/A Column BC in VBA

[Tardisgx]

[FONT=&quot]The columns relevant here are BA,BB&BC although I may put this data on a separate sheet just in A, B & C

The number of cells occupied and contents in BC changes. Which is why I can't press record and be happy.

[/FONT]
[FONT=&quot]On Columns BA,BB&BC data filter is applied.
[/FONT]
[FONT=&quot]I click the header drop down in BC and untick #/NA[/FONT]
[FONT=&quot]That's what I want to do in VBA. I messed up my attempts royally.[/FONT]

 

[Leith Ross]

Hello Tardisgx,

This will work for column "BA:BC". You can change it to whichever column you want to filter. This assumes these three columns are separated from AZ and BD.

Sub FilterWithoutNA()


    Dim Rng As Range
    
        ActiveSheet.AutoFilterMode = False
            
        Set Rng = Wks.Range("BA1:BC1").CurrentRegion
            Rng.AutoFilter Field:=3, Criteria1:="<>#N/A", VisibleDropDown:=True
        
End Sub