Previous active cell
 

Is there a way to capture the address of the last previous active cell. I am
trying to do this in the selection change code of a sheet but I cannot make
it work.

Thank you,

Steven

Previous active cell
 

See if this helps. Place in worksheet module
Public OldVALUE
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
MsgBox OldVALUE
OldVALUE = Target
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Steven" wrote in message
...
Is there a way to capture the address of the last previous active cell. I
am
trying to do this in the selection change code of a sheet but I cannot
make
it work.

Thank you,

Steven

Previous active cell
 

That is it. I am doing some things in the selection change and now I see
that I have to make that the last line of code in the sub routine so that
when I go to the next cell I am doing the testing before updating the
oldvalue again.

Thank you,

Steven

Thank you for your help.

"Don Guillett" wrote:

See if this helps. Place in worksheet module
Public OldVALUE
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
MsgBox OldVALUE
OldVALUE = Target
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Steven" wrote in message
...
Is there a way to capture the address of the last previous active cell. I
am
trying to do this in the selection change code of a sheet but I cannot
make
it work.

Thank you,

Steven