Thread: Why does this code remove Duplicate Values, by showing only 1, but it does NOT show Unique values for some reason ?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Corey Corey is offline
external usenet poster
  
Posts: 363
Default Why does this code remove Duplicate Values, by showing only 1, but it does NOT show Unique values for some reason ?
Thank you.
Perfect.
I will add that info to my growing VB vocabulary of knowledge.
"merjet" wrote in message
oups.com...
When a duplicate is found Err.Number < 0 and it stays that way.
Between the two "End If" stmts, insert "Err.Clear". That will reset
Err.Number = 0 and allow more additions.

Hth,
Merjet


Reply With QuoteReply With Quote