Need to Count unique items in a column in Excel (VBA)

To totally unlock this section you need to Log-in

Login

Scenario

I need to count the number of unique items in a column (excluding blank cells if possible) inVBA. I want to use the number as follows:

For x = 1 to (Number of unique items)

To control how many times I pass through a [gs loop].

Solution

[tweet]

To totally unlock this section you need to Log-in

Login