View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Abe[_4_] Abe[_4_] is offline
external usenet poster
 
Posts: 24
Default Removing a collection item via key name check

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