how to fix the error autofilter method of range class failed

gayatri

New Member
This the below code i am using:
Dim ws As Object
'Dim varUsedRange As Object

Try

ws = GetWorkSheet(Handle, Workbook, Worksheet)
'ws.Range("G:G").Select
'varUsedRange = ws.UsedRange().address
'If ws.AutoFilterMode Then
' ws.AutoFilterMode = False 'Turn off filters if already applied
'End If
ws.Range("A:AZ").Select
ws.Range("A:AZ").AutoFilter(field:=Column_Number, Criteria1:=Criteria)

Success = True

Catch e As Exception
Success = False
Message = e.Message
Finally
ws = Nothing
End Try
 
Top