Unique Advanced Filter to new sheet using dynamic range

[pauldaddyadams]

Hi,

I have spent some time googling this with no success. I would like to alter this:

Please Login or Register  to view this content.

End Sub


So it automatically find the last row based on on column b. This will help with one part of my problem in the post:

Can anyone help?

[MarvinP]

Perhaps,

Please Login or Register  to view this content.

Also, make the moderators happy and edit your post above, select your code and click on the "#" which will put "code tags" around your post and look more like mine.

Also - sometimes you need to "ClearContents" of the range you are copying your data to.

[pauldaddyadams]

Hi,

Thanks - I corrected after I posted but thanks for the heads up.

I have tried your code but I get a run time error 1004. Is it something I am doing wrong?

[jason.b75]

Hi Paul.

As this is part of the problem we are working on in your other thread could you please keep the discussion there.