How to Make a Cell that Just Changed the ActiveCell

[newuser2015]

I have code triggered to run as soon as the user enters a number in a certain range of cells. Is there a way to make it so that the cell that changed in this range is now the activecell?

So for example, if column A has the formula to add columns B + C and a user makes a change to B5 - how do I make cell A5 the activecell now which just changed because of the formula?


Private Sub Worksheet_Change(ByVal Target As Range)

If Not Application.Intersect(Target, Range("R2:R60000")) Is Nothing Then
My code which I am trying to get the cell that changed in this range to be the activecell
End If

End Sub

 

[Jonmo1]

It's not the formula changing that triggers the Worksheet_Change code.
It's the cell that the user typed in that triggers it.

I'm not aware of any means to track 'which' formula actually changed.
But we do know which ROW # was changed, that is Target.Row
If you know it's column A that is the formula
Then you can do

Range("A" & Target.Row).Select