| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
error runtime 9: deleting a worksheet
Hello,
I wrote following code and sometimes I get an runtime error 9. I don't really know when and why this error occurs. The value of test is never empty. On Error GoTo Marke Application.DisplayAlerts = False test = Worksheets("Länderansicht").Range("A" & i).Value ''''''''FEHLER'''''''''''''''''''''''''''''''''''' '''''''''''''' Worksheets(test).Select ''''''''''HIER TRITT DER FEHLER AUF '''''''FEHLER''''''''''''''''''''''''''''''''''''' '''''''''''''' Worksheets("Länderansicht").Select Worksheets("Länderansicht").Activate Worksheets(test).Delete Marke: Application.DisplayAlerts = True Tanks a lot, Michael |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro runtime 1004 error on opening worksheet | Excel Discussion (Misc queries) | |||
| Set worksheet range runtime error 1004 | Excel Programming | |||
| Validation.Modify Runtime Error in Protected Worksheet | Excel Programming | |||
| RUNTIME ERROR '1004' --- Select method of worksheet class failed | Excel Programming | |||
Threaded Mode
