Hi David,
Here is what I did. I defined nF as simply Dim nF, (although when I just now changed the program to Dim nF as Range, I got the same error). Fruit is the name I assigned in Excel to E2:E6. Also changing the statement to Set nF = Range("Fruit") doesn't eliminate the error.
You say, "Now a Cells() call takes two parameters, and the second must either be the number of the column you want, or its letter ("A", "B", etc)." I naively assumed that Cells(nrow, nF) (where I previously gave nrow the value 3), would mean the cell in row 3 in the range E2:E6, that is, E3. but I see it doesn't.
Actually, it seems to me that I'm not asking Excel to do anything special. If it can understand Cells(nrow, "E") means E3, where it picks out the cell I want from the whole column, it should be able to understand Cells (nrow, E2:E6) also means E3!
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?
Thanks for your 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 (16) |
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