Senin, 15 Oktober 2012

Re: [ExcelVBA] Abbreviations to Words

 

Cells(4,"E") also refers to E4 and is slightly more readable.

Regards, Dave S

----- Original Message -----
From: "Ralph Gregory" <ralph.gregory@skaino.co.uk>
To: <ExcelVBA@yahoogroups.com>
Sent: Tuesday, October 16, 2012 2: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" <mickey11030@yahoo.com>
To: "ExcelVBA@yahoogroups.com" <ExcelVBA@yahoogroups.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]

------------------------------------

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