Using AdvancedFilter to overwrite data

[JimDandy]

I'm using AdvancedFilter in a macro to copy unique values from one source worksheet to another destination worksheet. This works fine when the destination has no data in it, but not when I need to run the macro and update the data in the destination whenever the source changes. The number of rows in the source will vary but is over 130k rows.

Is there a way to perform this and overwrite the destination data?

The code I'm using:

Please Login or Register  to view this content.

[Norie]

What's the problem when you try and overwrite?

[JimDandy]

Running the Macro from the worksheet gives the 400 Error. Stepping through the macro in the VB editor I get "Run-time error '1004': Application-defined or object-defined error" when executing the AdvancedFilter line. It works without a problem if I clear the destination first.