GoTo cell..

[kashyap]

Hi, I have a Private Sub Worksheet_Change(ByVal target As Range) macro which does something when value changes in a particular cell..

But when user input any value they may press right arrow or down arrow..

Is there a way to go back to cell in which value was entered recently? as I need to perform some tasks over there..

 

[Smitty]

You can use Target.Select to reactivte the target cell.

HTH,