View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld[_2_] Ron Rosenfeld[_2_] is offline
external usenet poster
 
Posts: 1,045
Default Addressing ranges

On Tue, 15 Jun 2010 09:34:23 -0500, Dave Peterson
wrote:

I like the .offset() style better, but I think it's a personal (or
department/company) choice.


I used to use the Offset property frequently, but I've been starting
to use the Item property. I guess it is a personal preference,
although the Offset property would be my choice, I think, if I needed
to refer to an entire range, rather than just a single cell.


I have no idea if one is quicker than the other. And I don't care -- for the
same reasons that Jef wrote. (But you should be able to read and understand
both <vbg.)

Chip Pearson has some notes written by Alan Beban:
http://www.cpearson.com/excel/cells.htm

It may be an interesting read for you.


It was. Thanks.