View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default run time error 32809

Hi,

Am Tue, 3 Mar 2015 07:11:13 -0800 (PST) schrieb :

The error is pointing to the "Instructions" sheet (in this case it is also Sheet33


check the sheet name for leading or trailing spaces. Is the sheet
hidden?

try:
Private Sub Workbook_Open()
Application.Goto Sheets("Instructions").Range("A1")
End Sub


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional