I need some code that when I click on a worksheet tab that I go directly to
cell B3 each time on open. I have tried this code but it always opens at the
last EXCEL cell referenced before exiting the worksheet (i.e. h35).

Private Sub Worksheet_Open()
Application.Goto Reference:="R3C2"
End Sub

Can someone help with the correct code for this?

Try this:-

Private Sub Worksheet_Activate()
Range("B3").Select
End Sub

Right click the sheet tab, view code and paste this in.

Mike

"Tony" wrote:

I need some code that when I click on a worksheet tab that I go directly to
cell B3 each time on open. I have tried this code but it always opens at the
last EXCEL cell referenced before exiting the worksheet (i.e. h35).

Private Sub Worksheet_Open()
Application.Goto Reference:="R3C2"
End Sub

Can someone help with the correct code for this?