Am trying to store range objects in a Dictionary. am looping over a range of cells For Each c in ......
then storing via
dict.add key:=c.value, item:=c
when I look at and test ISOBJECT in Immediate window I get buggy results. retrieveing via index works, retrieveing via key does not.
dict.items(1) works & return a object, the cell.
dict.item("IMG") tests FALSE for isobject even though IMG is a valid key. I know cause it shows when
for each ky in dict.keys
debug,print ky
next ky
any ideas why I cannot retrieve the object using a key?
Dick
__._,_.___
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
.
__,_._,___
Tidak ada komentar:
Posting Komentar