Sabtu, 13 Oktober 2012

Re: [ExcelVBA] Abbreviations to Words

 

Hi Derek,

Thanks for being so patient with my slow learning process.

When I wrote 

nF = Range("Fruit")
nA = Range("Abb")
nrow = 3
Cells(nrow, nF).Value = clxFruit.Item("key" & Cells(nrow, nA).Value)

I was not trying to fill all of the named range nF. I had done some experiments that convinced me that Cells(nrow, nF) referred to a particular cell. That is, if nF refers to Col P, and nrow is 3, the reference is to Cell P3. 

Scratch That! I just realized that in my experiment, the named ranges I used were single cells. I created a named range nPay that referred to a cell with a value of 9 and nHours to a cell with a value of 30. The statement Cells(13,3) = nPay * nHours worked, and that convinced me (incorrectly) that Cells(nrow, nA) would also work. Enlightenment. Better late than never.

You mentions that processing could be speeded up if arrays were used, so that all the processing was done within VBA. You said you had discussed that in an earlier post. I'd appreciate your pointing me to that post.

Thank you for showing me the 4 ways of using Cells. That will be very useful.

Regards,
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 (14)
Recent Activity:
----------------------------------
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