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:

Please Login or Register  to view this content.

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.

Please Login or Register  to view this content.

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.

Please Login or Register  to view this content.

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

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.