View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Frank Krogh[_3_] Frank Krogh[_3_] is offline
external usenet poster
 
Posts: 5
Default How to retrieve the last selected cell before SelectionChange even

I am using the SelectionChange event like this:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Intersect(Target(1, 1), Range("m1:m1")) Is Nothing Then Exit Sub
....
End Sub

My question is if it's a way to retrieve which cell was selected before the
M1 cell is selected?

Regards

Frank Krogh