Thanks Chip. I hadn't run into dictionaries before, but I looked into
it and its definitely what I am looking for.
-Abe
Chip Pearson wrote:
You might consider using a Dictionary object rather than a
Collection object.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
wrote in message
ups.com...
I have a collection of range objects, called collXcells, and
each has a
key cooresponding to the range's R1C1 position (each range is
only 1
Excel cell). I.e. if there is a range object that is the A3
cell, its
key for collXcells is "R3C1".
Is there any easy way to check if a key in the collection
exists? and
if so remove the item associated with that key? (a way
easier--and
preferably more efficient-- than looping through all the
collection
objects keys, that is).
Thanks,
-Abe