(I don't think Jef's compatibility reason is as good as his first. I'm not
worried about that.)

On 06/15/2010 09:34, Dave Peterson wrote:
I like the .offset() style better, but I think it's a personal (or
department/company) choice.

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.



On 06/15/2010 06:48, Ron Rosenfeld wrote:
Dim c as Range

Assuming c is a single cell range, and I want to write a value into
the adjacent column, is there any advantage/disadvantage to using

c.offset(0,1)
vs
c(1,2)

??

c(1,2) is more compact.


--
Dave Peterson