Previous Property
Previous property as it applies to the Range object.
Returns a Range object that represents the previous cell. This property emulates pressing SHIFT+TAB; unlike the key combination, however, the property returns the previous cell without selecting it.
On a protected sheet, this property returns the previous unlocked cell. On an unprotected sheet, this property always returns the cell immediately to the left of the specified cell.
Using this property when the active cell in the specified range is in column A will result in a run-time error.
expression.Previous
*expression * Required. An expression that returns a Range object.
Previous property as it applies to the Worksheet object.
Returns a Worksheet object that represents the previous sheet.
expression.Previous
*expression * Required. An expression that returns a Worksheet object.
Example
As it applies to the Range object.
This example selects the previous unlocked cell on the active worksheet.
Spreadsheet1.ActiveCell.Previous.Select
Applies to | Range Object | Worksheet Object
See Also | Next Property