AutoFilter mehod of Range class failed

[kohatian]

Hello,
I have an excel file where I am trying to filter range of rows based on a macro but get an error: 'AutoFilter mehod of Range class failed'. Below is the macro code I am using:
Sub Button1_Click()

With ActiveSheet()
.AutoFilterMode = False
.Range("B12:B48").AutoFilter
.Range("B12:B48").AutoFilter Field:=2, Criteria1:=Range("B12:B48").Value

End With
End Sub

 

[Michael M]

You are using the entire range as your criteria....what do you want to filter by ??

Sub Button1_Click()

With ActiveSheet()
.AutoFilterMode = False
.Range("B12:B48").AutoFilter
.Range("$B$12:$B$48").AutoFilter Field:=1, Criteria1:=' a separate range like Range("B4").Value OR a value like "bob" or a number
End With
End Sub

 

[kohatian]

As I said I want to filter that range of rows and I want rest to be hidden which I click on this button.

 

[Michael M]

But filter for what ??
What is the item you are filtering for ???