Mea culpa!

I know you're right, I knew so before I wrote it, but I still wrote it with
the Offset value.

Bob


"Tom Ogilvy" wrote in message
...
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