Get unique, third smallest value in column.

Hi,

To find third smallest value in range (with some blank cells), I use:

Please Login or Register  to view this content.

That normally works but sometimes smallest and/or second smallest are duplicate values and then third smallest value will be wrong.
As I understand it, I need to find the, unique, third smallest value but I can't find any help at different sites.
Does anyone here know how to do that with VBA, or maybe point me in the right direction?

Any help will be much appreciated.
Thanks in advance!

Hi shg,
Thanks for quick reply.
Your code works exactly as I asked but unfortunately I gave you the wrong range.
Range is:

Please Login or Register  to view this content.

Is there a way to rewrite your code with this range? I tried but couldn't get it to work.
I found a code on internet which I rewrote to this:

Please Login or Register  to view this content.

Not so elegant but it works.

Thanks in advance!