In article ,
says...
Well I'll be darned... I only use cells when I need to increment through a
range so I have always used numbers. (Even then I normally use a range object
and offsets.)But you are absolutely correct. Thanks...

Yes, I rarely (never?) use Cells unless it is with number,number
indexing. Otherwise, I use Range("A1"). This is one of those
(infrequent?) instances where the software is a lot more flexible that
the documentation would lead one to believe. The same applies to the
Range property. It accepts a lot more variations in its arguments than
the documentation would lead one to believe.

Of course, that does leave people vulnerable to changes by MS. If it
breaks something that works but is not documented...{grin}

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions