Advanced Filter Macro for Unique List

Hello All

I am trying to write a macro which creates a unique list from a range of data and prompts the user for the source and destination. This is using the Adanced Filter Option:

Please Login or Register  to view this content.

All seems to be working except the last part where the list fails to be pasted to the specified destination.

Could anyone offer any suggestions as to where I'm going wrong please.

Many thanks.

Thanks very much for your response. I've done exactly as you've stated where at the various prompts, I select the entire range for the source and then just the first cell of the destination of the list, but nothing appears.

Ah! Sorry, missed that bit. Yes it works perfectly now, thank you.