While using Microsoft Visual Basic for Applications on Excel, if you get Run-time error, Class not registered, here is how you can fix the issue. It is pretty common when there are some issues ...

How to combine values into a single cell in .xls Excel files The newer features and functions that I’ll be using later in this article aren’t available in the earlier .xls format.

WorksheetFunction.CountIf (selRange, curCell.Value) > 1 is TRUE, meaning the current value occurs more than once in the data set.