Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
here is my awesome code:
Option Private Module Option Compare Binary Option Explicit Option Base 0 Public Const strDeleteSheet = "delSht" Private Sub deleteSheets() Dim xlSheet As Excel.Worksheet Application.DisplayAlerts = False For Each xlSheet In Application.ActiveWorkbook.Worksheets If (xlSheet.CodeName Like strDeleteSheet & "*") Then wkbActive.Worksheets(xlSheet.Name).Delete End If Next xlSheet Application.DisplayAlerts = True Set xlSheet = Nothing End Sub A not trappable error occurs: xlSheet.Name = <Automation error. The code does not stop processing. I know this is due to changing the items in ActiveWorkbook.Worksheets. This error resets globally declared variables to empty/false/etc... Any suggestions to delete sheets without resetting global variables? Thank you. rogge |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Compile error: Automation error in Excel 97 | Excel Programming | |||
Urgent!!! Run-time error '-2147024770 (8007007e)' Automation error | Excel Programming | |||
Delet certain row in a sheets in workbook | Excel Programming | |||
Run-Time Error'-2147221080(800401a8)': Automation Error | Excel Programming | |||
Unknown where is the problem on the Runtime error - Automation error | Excel Programming |