The Offset property in Excel VBA takes the range which is a particular number of rows and columns away from a certain range (border below for illustration only).
Place a command button on your worksheet and add the following code lines:
Dim example As Range Set example = Range(“A1:A2”) example.Offset(3, 2).Select
Result when you click the command button on the sheet:
Explanation: these code lines select the range which is 3 rows below and 2 columns to the right of Range(“A1:A2”). The Offset property always takes the top left cell of a range as the starting point.
For a practical example of the offset property, see our example program Create a Pattern.