Advanced Filter does not work in a recorded Macro

I recorded a macro to use Advanced Filtering but the Macro will not work.

When I recorded it, there were no issues and every time I run it manually it works.

There are no dates involved.

I am clearing any current data on the OutputSheet and then I am selecting a list of items on one worksheet and filtering out any duplicates so I am left with a unique list on the OutputSheet.

I position the cursor in call "A1" on "OutputSheet".

Code is below:

Sub CopyData

Sheets("OutputSheet").Range("A1:A100").Select
Selection.ClearContents
Sheets("OutputSheet").Range("A1").Select
Sheets("InputSheet").Range("F3:F100").AdvancedFilter Action=XlFilterCopy _
       , CopyToRange:=Sheets("OutputSheet").Range("A1"), Unique=True

End Sub

The input range includes a header (in F3).
The output position A1 is the header.

How does it not work?

PS Can you use code tags?

natefarm

When using code for advanced filter there's no restriction on where you can copy to.

Norie is correct! The following code works for me.

Sub Macro1()
    Sheets("OutputSheet").Columns(1).ClearContents
    EndRw = Range("A" & Rows.Count).End(xlUp).Row
    Range("F1:F" & EndRw).AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Sheets("OutputSheet").Range("A1"), Unique:=True
End Sub

You may also perform this manually but you must invoke the advanced filter with the destination sheet active.

Can you tell us what you range you want to filter, where the criteria is and where you want the results?

The code assumed that the current sheet is InputSheet. If that's not the case, select it at the beginning as follows.

Sub Macro1()
    Sheets("InputSheet").Select
    Sheets("OutputSheet").Columns(1).ClearContents
    EndRw = Range("A" & Rows.Count).End(xlUp).Row
    Range("F1:F" & EndRw).AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Sheets("OutputSheet").Range("A1"), Unique:=True
End Sub

natefarm

I'm getting confused here, who is the OP and who isn't?

Original Poster, the person who started the thread.

That would make sense. A filter basically hides rows, so if some of your rows were already hidden, they would be excluded from the copy.

Ok, I fixed it. Also changed from column A to F.