View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] uk swain.s@blueyonder.co uk is offline
external usenet poster
 
Posts: 64
Default run-time error '9': subscript out of range

i get the message wheh i try to run this

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Workbooks("DATA.XLS").Close SaveChanges:=False
End Sub