nFullNameColumn needs to contain the column number or column letter that the
result is to go into. I suspect you will simply want to give it the column
letter as a constant, e.g. "E". If you really want a variable, then make it
a string variable and give it the column identifier for the column that is
to be used ("A", "B", ... "IV").
Regards, Dave S
----- Original Message -----
From: "Michael Trombetta" <mickey11030@yahoo.com>
To: <ExcelVBA@yahoogroups.com>
Sent: Tuesday, October 16, 2012 2:14 AM
Subject: Re: [ExcelVBA] Abbreviations to Words
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]
------------------------------------
----------------------------------
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
----------------------------------Yahoo! Groups Links
-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1427 / Virus Database: 2441/5332 - Release Date: 10/14/12
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (29) |
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