View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tony tony is offline
external usenet poster
 
Posts: 313
Default Go To Cell Reference on Worksheet Open

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?