VBA Excel: Filter a column

Question

I am trying to filter a column as I had many times earlier. But getting error as below:

1004: "Autofilter method of Range class failed"

Set wkb1 = Workbooks.Open("D:\Meru\Work\Trace Reports\Automation\Macro Codes\" & CFname & "\Daily Pivots -" & CfolderN & ".xls")

With wkb1.Worksheets("winloss")
    LastRow5 = .Cells(.Rows.Count, "A").End(xlUp).Row
    'MsgBox LastRow
    Set My_Range = .Range("V1:V" & LastRow5)
    'MsgBox My_Range
    My_Range.AutoFilter Field:=22, Criteria1:="Won", Operator:=xlFilterValues
  '   LastRow = .Cells(.Rows.Count, "G").End(xlUp).Row

    .UsedRange.Copy
End With

With wkb1.Worksheets("Trial")
    .Range(.Cells(1, "A"), .Cells(LastRow5, "A")).PasteSpecial xlPasteValues
End With

Subodh Tiwari sktneer · Accepted Answer · 2017-05-05 08:42:43Z

3

Since the range to be filtered contains only one column, it should be like this...

My_Range.AutoFilter Field:=1, Criteria1:="Won", Operator:=xlFilterValues

answered May 5, 2017 at 8:42

Subodh Tiwari sktneer

9,9862 gold badges20 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Subodh Tiwari sktneer Over a year ago

You're welcome Meru! Glad I could help. Please take a moment to accept the answer to mark your question as Solved.

Collectives™ on Stack Overflow

VBA Excel: Filter a column

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related