Code skips on Run Mode but runs fine on F8 (Debug Mode)

Hi! I have a code that finds the duplicates of column A and merges some columns on the same row according to how many duplicates are in the column A.

When I run the code pressing F8 everything works marvelous but when I run it as it's supposed to run (F5) then it just won't merge anything.

Can anyone help me, please? This is driving me nuts and it's the last thing I need to fix for presenting a project to my boss

Please Login or Register  to view this content.

Thanks for reading ^^

Try this (only cleaning the code a bit), for me this actually works:

Please Login or Register  to view this content.

However, I feel there may be more efficient ways ways to do this

Berlan... you are a GENIUS. Simplyfing the code made it work. Thank you very much! +rep for you ^^

Originally Posted by berlan

Try this (only cleaning the code a bit), for me this actually works:

Please Login or Register  to view this content.

Solus, unfortunately, I can't as it contains company's sensitive info.

Originally Posted by Solus Rankin

Can you post a workbook with sample data?

RequelAR, you can always replace any sensitive data with dummy data

Originally Posted by RaquelAR

Berlan... you are a GENIUS. Simplyfing the code made it work. Thank you very much! +rep for you ^^

Solus, unfortunately, I can't as it contains company's sensitive info.

Oh many thanks!! You're welcome!

All best