ActiveWorkbook.Worksheets(i).DeleteĮrrorLogging MODULENAME & ".Clear_Workbook()", Err.Number, Err.Description, Erlīasically, what's happening is that when it goes to delete one of programmatically generated sheets from the previous run, it deletes the sheet, then immediately drops down to the error handler, and when it tries to execute the error handler crashes. ![]() InStr(ActiveWorkbook.Worksheets(i).Name, "SSJSY - ") 0 Then ![]() ![]() If InStr(ActiveWorkbook.Worksheets(i).Name, "SSPNT - ") 0 Or _
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |