Deleting rows

[azizrasul]

I want to delete rows based values other than specific values. Here's the code I am using which gives me an error on the .Delete line.

Set ws = ThisWorkbook.Sheets("tblComputerSystemInformation")

With ws.Range("C2:C" & WorksheetFunction.CountA(Range("tblComputerSystemInformation[nametype]")))
        .AutoFilter Field:=4, Criteria1:="Not In ('OSArchitecture','Name','OSLanguage')"
        .SpecialCells(xlCellTypeVisible).Delete
End With

In MS Access you can use criteria like

Not In ('OSArchitecture','Name','OSLanguage')

Is it possible to do something similar in MS Excel?

 

[MARK858]

As I stated earlier that depends on the version of Excel that they have. All recent versions of Excel have Power Query/Get and Transform built in (that is why it is important that you show what version of Excel you have in your profile, if you had a version earlier than 2010 then Power Query wouldn't have been an option).

 

[azizrasul]

As I stated earlier that depends on the version of Excel that they have. All recent versions of Excel have Power Query/Get and Transform built in (that is why it is important that you show what version of Excel you have in your profile, if you had a version earlier than 2010 then Power Query wouldn't have been an option).

OK I understand.