If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Visual Basics Error - Goto
Either:
Private Sub CommandButton1_Click() Application.Goto ActiveWorkbook.Sheets("WGTN & KAPITI").Range("Garry"), _ scroll:=true 'or false End Sub or Private Sub CommandButton1_Click() with ActiveWorkbook.Sheets("WGTN & KAPITI") .Activate .range("garry").Activate 'or .select end with End Sub Shirl wrote: 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 -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|