Senin, 15 Oktober 2012

Re: [ExcelVBA] Abbreviations to Words

 

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