Applies To
Application Object.
Description
Accessor. Returns an array of the four previous ranges or names selected. Each element in the array is a Range object. Read-only. Each time you go to a range or cell using the name box or Go To command (Edit menu), or a macro calls the Goto method, whatever range was selected before is added to this array as element number one, and the other items in the array are moved down.
Example
This example displays the cell addresses of all items in the array of previous selections. If there are no previous selections, the LBound function returns an error. This error is trapped, and a message box appears.
On Error GoTo noSelections
For i = LBound(Application.PreviousSelections) To _
UBound(Application.PreviousSelections)
MsgBox Application.PreviousSelections(i).Address
Next i
Exit Sub
On Error GoTo 0
noSelections:
MsgBox "There are no previous selections"