SelectionChange event
 

When I change selectio in a worksheet, the range that I select is passed to
the SelectionChange event as Target. How can I identify the range that I have
changed from?

SelectionChange event
 

You would need to put in a static variable in the selectionchange event and
update it as you exit the selectionchange event.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim oldSelection as Static

' code that does things


set OldSelection = Target

End Sub

if you will have to use this value on the very first selectionchange, then
you will need to make it a public variable in a general module and
initialize it in the Workbook_Open event.

--
Regards,
Tom Ogilvy


"Hayeso" wrote in message
...
When I change selectio in a worksheet, the range that I select is passed
to
the SelectionChange event as Target. How can I identify the range that I
have
changed from?

SelectionChange event
 

Thanks Tom, That makes sense.

"Tom Ogilvy" wrote:

You would need to put in a static variable in the selectionchange event and
update it as you exit the selectionchange event.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim oldSelection as Static

' code that does things


set OldSelection = Target

End Sub

if you will have to use this value on the very first selectionchange, then
you will need to make it a public variable in a general module and
initialize it in the Workbook_Open event.

--
Regards,
Tom Ogilvy


"Hayeso" wrote in message
...
When I change selectio in a worksheet, the range that I select is passed
to
the SelectionChange event as Target. How can I identify the range that I
have
changed from?