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