Previous Property Example

This example selects the previous unlocked cell on Sheet1. If Sheet1 is unprotected, this is the cell immediately to the left of the active cell.

Worksheets("Sheet1").Activate
ActiveCell.Previous.Select