Combine rows, no data loss

I was trying to find a combinator algorithm online, for excel sheets, and I found this webpage

https://www.extendoffice.com/documen...ame-value.html

Now I really need to figure the following algorithm from that page, and how possible is it that this algorithm is erroneous, like misses some data, or removes some.

Can someone walk me through each line of the algorithm and tell me what it does?

Please Login or Register  to view this content.

Also I really think it is a good learning practice as well.

Hi xinx,

VBA Code like any code is like writing a story. Some are easier and others are more direct. The code you copied above is part of Kutools and can be done much easier than what they show. The create a variable type of "Collection" to gather those color words. They use variable names that don't make sense to me. If you are a good writer (and coder) you should pick variable names that have meaning like "LastRowA", meaning the last row in column A. That way when you (or others) read your code they don't need to look up to the original Dim statement to see what it means. I've written my own code to do the exact same thing as what you posted. Follow my code to see if you can learn from it.

Please Login or Register  to view this content.

Combine Colors VBA.xlsm