Re: [ExcelVBA] Abbreviations to Words

 

Derek,

I copied your code into my spreadsheet, and of course it worked, but I don't know why. I don't understand your comment. "You have to get the collection items out one by one, you cannot use range methods." But in the statement,

 Cells(2, 3).Value = clxFruit.Item(("key" & Range("A2").Value))

you use Cells on the left side and Range on the right. Then, in an apparent change, in the For loop, you use

Cells(nRow, "c").Value = clxFruit.Item(("key" & Cells(nRow, "a").Value))

with Cells on both sides.

What am I missing?

Thanks,
Michael Trombetta

[Non-text portions of this message have been removed]

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (12)

Recent Activity:

• New Members 4

Visit Your Group

----------------------------------
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

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___