VBA modification to exclude empty cells, just need help implementing!!

[cronerd]

I have a VBA that pulls Unique values from a set of cells. My problem is that I do not want it to include empty cells as a unique cell, it currently treats the empty cells as unique and gives me back a "0". Below I have my VBA, also someone tried to help me with a modification that would ignore empty cells but I haven't been able to modify it correctly so if anyone could help me with this I would be deeply appreciative.

Note: I have highlighted in blue the area where I tried to input the modification code, if anyone understands VBA and knows how to incorporate the code in purple into the code in blue correctly it would solve my problem!
VBA:

Please Login or Register  to view this content.

Below is the Code given to me by other person, I was told to place this into the blue colored code above, but it didn't work :/

Please Login or Register  to view this content.

[Solus Rankin]

Please put your code in code brackets. Click edit post, highlight the code and press the #.

On another note the yellow is nearly impossible to read on my screen.

[cronerd]

Fixed! thanks XeRo Solus!

[AB33]

You can use the len function to exclude the null.

Please Login or Register  to view this content.

[AB33]

Please Login or Register  to view this content.

[cronerd]

would I then replace it with the entire blue part of the code? what happens to the myColl.Remore "String" section?

[cronerd]

Think I got it! Like this?

Please Login or Register  to view this content.

[AB33]

It remains there.
I have just added to you existing line to exclude null string.

[cronerd]

Thanks for helping me through that!! Case solved.