Wednesday, May 23, 2012

Renaming Key of Item in Collection with VBA in Excel

I have a collection as follows:



Set NodeColl = New Collection
NodeColl.Add "Node 1", "Node 1"
NodeColl.Add "Node 2", "Node 2"
NodeColl.Add "Node 3", "Node 3"


I am wondering if there is an easy way to rename the keys of selective items without affecting other items or the collection itself. For example, something like NodeColl.Items("Node 1").Key = "Some string"





No comments:

Post a Comment