understands range("e2:e20")
or
range(cells(2,"e"),cells(20,"e"))
or
understands range("e2:e20").offset(4)
or
range(cells(2,"e"),cells(20,"e")).offset(4)
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguillett1@gmail.com
From: Michael Trombetta
Sent: Monday, October 15, 2012 2:17 PM
To: ExcelVBA@yahoogroups.com
Subject: Re: [ExcelVBA] Abbreviations to Words
Thanks, but I realize that Cells(4,5) refers to a particular cell. I just wonder why Excel can understand Cells(4,"E") but not Cells(4, E2:E20), but I guess that's just how it is.
________________________________
From: Ralph Gregory <mailto:ralph.gregory%40skaino.co.uk>
To: mailto:ExcelVBA%40yahoogroups.com
Sent: Monday, October 15, 2012 11:58 AM
Subject: Re: [ExcelVBA] Abbreviations to Words
Cells(4,5) references the 4th row and the 5th column which equates to E4 The numbers can be substituted with variables if needed
Ralph Gregory
Contracts Manager
Skaino Services
West March
DAVENTRY
NN11 4SA
----- Reply message -----
From: "Michael Trombetta" <mailto:mickey11030%40yahoo.com>
To: "mailto:ExcelVBA%40yahoogroups.com" <mailto:ExcelVBA%40yahoogroups.com>
Subject: [ExcelVBA] Abbreviations to Words
Date: Mon, Oct 15, 2012 4:14 pm
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]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[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 (4) |
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