excel+training - Offset

Belinda

The Offset property of a range is most commonly seen when a macro is recorded using Relative reference.

It enable the user to manipulate a cell based off the location of the active cell.

The syntax is

Range.OffSet (RowOffset, ColumnOffset)

eg

Range ("A1").OffSet (4,5)

If you need to know at any given moment the cell you are manipulating then you need to use a variable as a indicator of the cells address.

eg

Dim Row as Integer

Cells(Row,5).Copy

Hope this helps.

Carlos