Particular cell in Range
Think you are off by one (since this notation is one's based)
? Range("A1:Z26")(3,4).row
3
? Range("A1:Z26")(3,4).Column
4
so rng(3,4) would be cell at the 3rd row and 4th column with the first cell
in rng as the base (1,1) location.
Regards,
Tom Ogilvy
Bob Phillips wrote in message
...
A bit more flexible, that allows referencing a point into this grid
without
necessarily knowing, or caring, about where it is in absolute terms is to
use
rng(x,y)
where rng is a defined range, x is the relative row, and y is the relative
column. SO, rng(3,4) would be row 4 and column 5 within the area defined
by
rng.
--
HTH
Bob Phillips
"Jeff C." wrote in message
...
Reference the appropriate cell using:
cells(row,col)
Where Row and Col are integer values corresponding to the
cell you are referencing.
Example Cell b5 is cells(5,2)
-- Jeff
|