It's short coding for item/cells property of the range collection...


Range("b2")= Range("a1")(2,2)=[a1].offset(1,1)


Lotsa ways to refer to a cell :)




keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Otto Moehrbach" wrote:

Excel 2002, Win XP
Chip Pearson responded to a poster with a Worksheet_Change event macro
that included the line:
Target(1, 4).Value = Now
The Target(1,4) term is new to me. I played with it and it acts like
an Offset of (0,3).
What does the (1,4) in Target(1,4) mean? Thanks for your help. Otto