You might try using a Dictionary object. Have a look at
http://www.cpearson.com/excel/Collec...ctionaries.htm for VBA utility
procedures for Dictionaries and Collections. To use a dictionary, you'll
need a reference (in VBA, Tools menu, References) to the "Microsoft
Scripting Runtime" library.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email on the web site)


"Dev" wrote in message
...
I am trying to create a hashtable with key value pairs - where both key and
value are strings. How to do this using VBA?

Thanks for any help!