Hi X Taol,

Try something like:

'=============
Public Sub Tester001()
Dim rng As Range

Set rng = ActiveCell

'your code, e.g.:
ActiveSheet.Next.Select

Application.Goto rng

End Sub
'<<=============



--
---
Regards,
Norman



"x taol" wrote in message
...


i want to go to previous location for excel using.
Namely, to previous sheet or previous cell.
how can i?

*** Sent via Developersdex http://www.developersdex.com ***