Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Stops without reason
Hi All,
I have a macro which after executing some instruction, stops at certain line. This did not happen initially. And when it does, it usually stops on the same line of Macro code. I did not hit the ctrl-Pause key (or ctrl -break), not even touch the keyboard. Please help. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Stops without reason
1) did any Error messages appear? 2) Comment out any ON error Statements to help isolate the problem 3) Change break on Error option from VBA menu Tools - OPtions - General - Break on Error - Break on All Errors -- joel ------------------------------------------------------------------------ joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=150357 Microsoft Office Help |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Stops without reason
hi
usually stops on the same line of Macro code. does that mean it stops on other lines at time????? post your code for evaluation. highlight the problem line(s). regards FSt1 "ch" wrote: Hi All, I have a macro which after executing some instruction, stops at certain line. This did not happen initially. And when it does, it usually stops on the same line of Macro code. I did not hit the ctrl-Pause key (or ctrl -break), not even touch the keyboard. Please help. Thanks. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Stops without reason
FWIW, I've seen the same thing intermittently and I can continue execution
with no errors. "ch" wrote: Hi All, I have a macro which after executing some instruction, stops at certain line. This did not happen initially. And when it does, it usually stops on the same line of Macro code. I did not hit the ctrl-Pause key (or ctrl -break), not even touch the keyboard. Please help. Thanks. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Stops without reason
Are you opening another workbook?
Are you running the macro using a shortcut key? If yes to both, then remove the shift from the shortcut key combination. ch wrote: Hi All, I have a macro which after executing some instruction, stops at certain line. This did not happen initially. And when it does, it usually stops on the same line of Macro code. I did not hit the ctrl-Pause key (or ctrl -break), not even touch the keyboard. Please help. Thanks. -- Dave Peterson |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Stops without reason
The codes will not reveal much. Problem is intermittent. It has stopped happening now. When code does stops, it has no error code or comment. I just key F5 to continue execute the rest of the codes. Barb (see below) has the same problem. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Stops without reason
Thanks for feedback. I think this could be a bug' inherent to Excel. I do not get real problems besides the inconvenience for the need to manually key "F5" to continue the program. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code stops for no reason (that I can think of) | Excel Programming | |||
Macro stops for no reason | Excel Programming | |||
macro doesn't hide columns for an unexplicable reason | Excel Programming | |||
Code stops for no apparent reason | Excel Programming | |||
My Macro stops | Excel Programming |