Get current cell position BEFORE it jumps to next cell

[gtaborda]

Hi

I use Sub Worksheet_SelectionChange(ByVal Target As Range)
currentcolumn = ActiveCell.Column
currentrow = ActiveCell.Row
...

to detect the current cell position.

However this Sub runs when it jumps to the new Cell.

I need to know the position for the Cell the cursor just left...

For example, I am in CELL A2 and I type "HELLO" then [ENTER] key.
The cursor automatically jumps to cell B2 and the Sub Worksheet_SelectionChange routine gives me cell position for B2 but I want to get the A2 position.

Can anyone help ?
thanks

 

[combo]

Private Sub Workbook_Open()
Set Sheet1.rngPrevSel = ThisWorkbook.Windows(1).Selection
End Sub

Public rngPrevSel As Range, rngOldTarget As Range

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Set rngOldTarget = rngPrevSel
Set rngPrevSel = Target
MsgBox rngOldTarget.Address
End Sub

combo

 

[AnotherHiggins]

gtaborda,

VBA specific questions belong in forum707.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[combo]

The Worksheet_Change event seems to be more convenient for the situation mentioned in the second part of your post.

combo

 

[gtaborda]

Sorry anotherhiggins, I didn't realize I was on the wrong forum.

Thanks combo for your code...I've tried it but I get some errors...will need to double check it.

thanks