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" <(E-Mail Removed)> wrote in message
news:F8517F41-B69B-42DD-82CD-(E-Mail Removed)...
>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!

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!