Find the previous row selected?

[ballack]

Hi ,I have a question,

When user clicks on different cell the following function is called.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Now if ,imagine the user is in row 3 and he clicks on row 10, Worksheet_SelectionChange(ByVal Target As Range) function is called, Now in this function Target.Row will give the present row that is 10 ,

but how can i find previous row which the user was in (i.e 3) ?

Thank you.
Glen

[Reafidy]

You need to wrap code with code tags

try:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Static OldTarget As String
    MsgBox OldTarget
    OldTarget = Target.Address
End Sub

[Reafidy]

Sorry my last post gave you the cell address I see you want the row try this:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Static OldTargetRow As Long
    MsgBox OldTargetRow
    If Not Target.Count > 1 Then
        OldTargetRow = Target.Row
    End If
End Sub

[ballack]

Thanks Reafidy,
Thats wat i wanted.

How does the oldTargetRow return the previous row without being initialized?

[Reafidy]

Hi,

Its due to being dimensioned as static. Im not good at explaining so from the help files:

Static Statement

Used at procedure level to declare variables and allocate storage space. Variables declared with the Static statement retain their values as long as the code is running.