Delete rows from the bottom up

[madsklavsen]

Hello,

I have the following code:

Please Login or Register  to view this content.

Is it possible for the macro to work from the bottom-up? By this i mean that it should delete the duplicate which is placed first in the range. (E.g. if there is a duplicate in B19 and B24, it should delete the duplicate in B19 first. Atm it's reversed.

Can you please help me?
Thanks in advance

[Kamboj]

change delete code line as

Please Login or Register  to view this content.

[madsklavsen]

Hi Kamboj,

Thanks for you response!
This doesn't seem to change anything?

Let me try to reformulate the problem:
I want the macro to delete the cells in the top of the range first, so if a duplicate is in B19 and B24, i want the macro to delete cell B24.

Thanks again!

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[madsklavsen]

This doesn't seem to work either John. Thanks for your response!

[Kamboj]

use this

Please Login or Register  to view this content.

[madsklavsen]

Hi Kamboj,

Nothing seems to happen when i run the macro you just sent me.

Should i insert anything into the "". Excuse me if i ask dumb questions, i am rather new when it comes to VBA.

Thanks!

[Trebor76]

As long as there's duplicates this will work:

Please Login or Register  to view this content.

Regards,

Robert

[madsklavsen]

Hi Robert,
It works perfect now, even when no duplicates exist. Thanks a lot!

[Trebor76]

It works perfect now, even when no duplicates exist. Thanks a lot!

What I actually meant was that it will delete all duplicates from the bottom up. It will of course run (though do nothing) if there's no duplicates.

I'm glad we got it sorted for you and thanks for the rep

Robert