On Jun 15, 7:48*am, 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.

Havent seen this abbreviated style before so if it works, the problems
I would foresee would be
1) more difficult for others to decipher your code
2) possibly incompatible with alternative software/future versions.