View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Shirl Shirl is offline
external usenet poster
 
Posts: 4
Default Visual Basics Error - Goto

Please help. I keep getting an error from my visual basics code. Click on a
button on a sheet takes you to another sheet within the same workbook then
directly to specific cells. Don't know whats wrong with the code.

Private Sub CommandButton1_Click()
Application.Goto ActiveWorkbook.Sheets("WGTN & KAPITI").Activate
ActiveSheet.Range("Garry").Activate
End Sub
--
Shirl, NZ