Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activesheet.delete
I have a procedure which at one stage loops through a number of sheets in my workbook deleting them until it comes to a particular sheet, at which point it moves on to the next stage in the procedure. I have a problem at a later stage in the procedure and I want to step through the procedure to find out where the problem is. The trouble I have is that whenever the procedure reaches the sheet deletion stage a message comes up saying 'Can't enter break mode at this time', consequently I am unable to locate where the later problem is
Does anyone know why this happens and is there a work around TI Ron |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activesheet.delete
You could put a break point in just before the problem
section and then run the code. The code will stop at the break point and you can step through from there. Alternatively, replace the deletion temporarily with something else such as hiding the sheet. -----Original Message----- I have a procedure which at one stage loops through a number of sheets in my workbook deleting them until it comes to a particular sheet, at which point it moves on to the next stage in the procedure. I have a problem at a later stage in the procedure and I want to step through the procedure to find out where the problem is. The trouble I have is that whenever the procedure reaches the sheet deletion stage a message comes up saying 'Can't enter break mode at this time', consequently I am unable to locate where the later problem is. Does anyone know why this happens and is there a work around? TIA Ron . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
name of the activesheet | Excel Programming | |||
ActiveSheet.Name? | Excel Programming | |||
ActiveSheet | Excel Programming | |||
ActiveSheet | Excel Programming | |||
ActiveSheet | Excel Programming |