Jump to a cell and back??

Hi all again

So i have part fixed my previous problem with the following code:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row = 5 Then
Target.Offset(55, 0).Select

End If
End Sub

But basically I want users to enter data in cell B5 - then be taken down to the table (at around row 60) but have the cursor go back to B5 after so they can change the data for the table.

So when they go back to B5 - the table remains visible as I have now frozen the pane at B5

Any suggestions?

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