View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Myriam Myriam is offline
external usenet poster
 
Posts: 97
Default run-time error 91

I'm having trouble with a runtime error 91. I tried to place an "On Error
Resume Next " but it only freezes the user form. What am I missing?

Private Sub OpenWkbk_Click()
Dim frmOpenWkbk As Object
Workbooks.Open Sheets("mySheet").Range("myRange").Value
frmOpenWkbk.Hide
End Sub

Thanks for your help.