Previous Property
This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.
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