[dba-Tech] Excel question: go to a named range?

Susan Harkins ssharkins at gmail.com
Fri Aug 17 19:19:13 CDT 2007


Arthur, I'm not positive, but look into the Cells property:

rangeobject.cells(row,column)

Susan H. 

Hi all,

I have three similarly named ranges in a worksheet. Depending on values
external to the ranges, I need to populate various cells in one of the three
ranges. Each range consists of a column containing titles and a column to
contain the values. I know how to select a range, but I don't think that's
what I want to do. Instead, given external value A I want to go to the range
corresponding to A and enter values into its second column. I want to go to
the named range's first cell (well actually, the first cell in the second
column). Is there a convenient "relative" way to refer to the cells in a
range, relative to the first cell, something like offset?

TIA,
Arthur
_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.476 / Virus Database: 269.11.19/953 - Release Date: 8/14/2007
5:19 PM
 




More information about the dba-Tech mailing list