Re: Long-hand references vs short-hand

"JonWayn" <JonWayn@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8B5512D6-9D06-4C6B-B5C2-B73146A033DF@xxxxxxxxxxxxx
Is there any functional differences between the construct:
Set CurRow = TblPersonalInfo.Rows(1)
Set CellsColl = CurRow.Cells
Set CurCell = CellsColl(0)
and
SetCurCell = TblPersonalInfo.Rows.Item(1).Cells.Item(0)
?

No, not really. You can make it even shorter:

Set CurCell = TblPersonalInfo.Rows(1).Cells(0)

--
With best wishes,
Igor Tandetnik

With sufficient thrust, pigs fly just fine. However, this is not
necessarily a good idea. It is hard to be sure where they are going to
land, and it could be dangerous sitting under them as they fly
overhead. -- RFC 1925


.