Ivan,
Look at the VBA "Find" function - see VBA Help.

Can you give n example of what are "distinct" values?

"Ivan" wrote:

Dear all,

I have encountered a problem which makes me frustrated. I need to find out
all the distinct values in a specific column of an Excel worksheet. How can I
do it programatically? Any suggestion? Please advise.
Thanks in advance!

Ivan