Hi Vic,

If you qualify the Cells method with a Worksheet object, it will use the
first cell (A1) on that worksheet as the anchor. This means you can't use
a
negative number as one of it's arguments because there are no negative row
numbers or negative column numbers on a worksheet.
..
And, of course, if the Cells property is qualified with any object qualifier
other than a range object, or is used without explicit qualification, no
natural number index values can be used because they would implicitly expand
the worksheet beyond the restrictions of its 65536 x 256 boundary.

In short, the Cells property will not permit any index (other than 0)
unless it is qualified by a suitable range object.


---
Regards,
Norman


"Vic Eldridge" wrote in message
...
If you qualify the Cells method with a Worksheet object, it will use the
first cell (A1) on that worksheet as the anchor. This means you can't use
a
negative number as one of it's arguments because there are no negative row
numbers or negative column numbers on a worksheet.

If, on the other hand, you qualify the Cells method with a Range object,
it
will use the first cell in that Range as the anchor, and you can offset
negatively from that anchor as far as you like (as long as it doesn't end
up
beyond the edges of the worksheet).

---
Regards,
Norman