David,
I'm not trying to work on multiple cells; I thought Cells(4, E2:E7) was a way to select E4, but I see that does not work.
Early in this thread, Derek posted the following
Cells(nRow, nFullNameColumn).Value = clxFruit.Item("key" & nAbbreviatedNameColumn)
nRow is an index in a For loop, and I assumed nFullNameColumn was a variable associated with a named range on the sheet. How does nFullNameColumn have to be defined and assigned a value to make this statement work?
At the end of my last post I asked this question: With Fruit a defined name on a sheet, and nF defined by Dim nF as Range, what value does the statement Set nF = Range("Fruit") assign to nF? does anyone know the answer to that question?
Thanks for all the help,
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 (18) |
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