code worked but not now??

[Mungyun]

Im extremely stumped with this situation i have. I have excel worksheet with quite a bit of functionality and one of the things it does is copy some data from another workbook and then filter out the unique records in certain columns. About 30 minutes ago, excel got glitchy(what else is new) and i ended up closing everything down and opening back up. I tried running the code that filters the data and nothing happened. I stepped through it and watched it supposedly run the code but it never filtered the column i wanted. All it did was copy the header and one of the cells to be filtered whereas before it worked perfectly. I then close down everything, open back up and it may or may not work..

Just so you can understand here is my filter code. i recorded it and it is identical to the code excel gave me from when i recorded it.

Please Login or Register  to view this content.

Any info or comments on whats going on would be greatly appreciated

[mrice]

You don't appear to have a criteria range which should include your selected column headers and a blank row underneath.

e.g.

Please Login or Register  to view this content.

[Leith Ross]

Hello mrice,

The Criteria argument is ignored when the Unique flag is set to True.

Sincerely,
Leith Ross