Analytics with Excel______________________________________RaviKanth Janapareddy
The Offset property
lets you refer to a cell that is a particular number of rows and columns away from another cell.
Range(“A1”).Offset(1, 2)
Range(“C2”).Offset(-1, -2)
Range(“A1”).Offset(0, 0)
No comments:
Post a Comment