Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VBA Make array unique

Status
Not open for further replies.
steinfeld

steinfeld

IS-IT--Management
Feb 21, 2006
25
US
How do I get an array that has duplicates to contain only unique values.

MyArray kpp-1, kpp-2, kpp-2, kpp-3

I want it like kpp-1, kpp-2, kpp-3
 
Sort by date Sort by votes
Use a VBA Collection or a Scripting.Dictionary object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

K
  • Locked
  • Question
How to resolve define worksheets array
Replies
1
Views
786
combo
combo
thanhthanh12
  • Locked
  • Question
Help vba
Replies
3
Views
694
combo
combo
Andrzejek
  • Locked
  • Question
Outlook VBA - Trust access
Replies
3
Views
1K
hermanlaksko
hermanlaksko
remeng
  • Locked
  • Question
Getting results from a dynamic dimension array
Replies
2
Views
712
Andrzejek
Andrzejek
SLW89
  • Locked
  • Question
VBA newbie needs help
Replies
4
Views
635
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top