Macro AutoRun

[SiGill]

I have a macro that runs when a value is changed in a cell. But it moves me to Cell A1 once run and I have to click back to where I was, i.e. line 200.

Is there a way to get the macro to run but then to take me back to the cell I was in?

Code at the moment is just

Private Sub Worksheet_Change(ByVal Target As Range)
Call Sort
End Sub

Thanks

 

[chergh]

Private Sub Worksheet_Change(ByVal Target As Range)
Call Sort
target.select
End Sub