Jump to a cell and back??

So you need a time delay so that after a certain amount of time it goes back to B5?

Something like this:

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Row = 5 Then
 Target.Offset(55, 0).Select
 Application.Wait Now + TimeValue("0:00:05") '5 seconds
 Target.Select
End If

End Sub

Note: Using Application.GoTo would allow for more exact locations