View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Noepie Noepie is offline
external usenet poster
 
Posts: 15
Default Error message on Opening

Hello,

I get an error message on opening a workbook when the sheet "Invoer" is not
active. If it is then the error message doesn't occur. The code is as follows:
__________
Private Sub Workbook_Open()
With Application
Sheets("Portefeuille").Range("Data").ClearContents
Sheets("Invoer").Range("e3").Select
End With
End Sub
___________
Does anyone know what goes wrong.

Regards,

Noepie