Unique Advanced Filter to new sheet using dynamic range

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:

HTML Code: 

Can anyone help?

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?

Hi Paul.

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