Thread: Error 91 while trying to save a workbook
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Adam_needs_help Adam_needs_help is offline
external usenet poster
  
Posts: 19
Default Error 91 while trying to save a workbook
Here is my code, any idea why I ma getting error 91? I use the same basic
code elsewhere and it works. I think there may be an error in which workbook
is active. I am trying to save the workbook I just copied a sheet into.

Windows("Make_The_MasterFile.xls").Activate 'not trying to save this workbook
Sheets("OverallBigHitters").Activate
ActiveSheet.Select
ActiveSheet.Copy 'trying to save this one
WBforBigHit = ActiveWorkbook.Name

Reply With QuoteReply With Quote