Hello, I am getting the error message “AutoFilter method of range class failed” for the following code: Sheets("Step 4").Select Dim lastrow3 As Long lastrow3 = Range("A" & Rows.Count).End(xlUp).Row ActiveSheet.Range("A3:E" & lastrow3).AutoFilter Field:=5, Criteria1:="=Yes", _ Operator:=xlOr, Criteria2:="=#N/A" I want it to filter a range (which changes when the macro is run each week) by “Yes” and “N/A”. Thanks!:confused:

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

VBA filter a range which changes

Thread starter Watson85
Start date Jun 16, 2015

Watson85

New Member

Jun 16, 2015

Hello,

I am getting the error message “AutoFilter method of range class failed” for the following code:

Sheets("Step 4").Select
Dim lastrow3 As Long
lastrow3 = Range("A" & Rows.Count).End(xlUp).Row
ActiveSheet.Range("A3:E" & lastrow3).AutoFilter Field:=5, Criteria1:="=Yes", _
Operator:=xlOr, Criteria2:="=#N/A"

I want it to filter a range (which changes when the macro is run each week) by “Yes” and “N/A”.

Thanks!