Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code exucution stopping spontaneously
I have a number of spreadsheets with code.
This week two of them on different PCs have begun spontaneosuly breaking during execution, with a message "Code execution has been halted". With options to debug, end or continue. They generally break in the same place, and I cannot find a way to make them run properly. (One one a 'paste special' line, the other on a 'wend') They used to run OK , and still do on other machines. (The sheet has been copied from a common location on to local machines.) I have tried removing all break points (even though there aren't any in there) I have added a break at the rogue position and then removed it again. I have put in an extra line of code, compiled, taken the line out and compiled again, but still the VBA routine breaks. On the 'rogue' machine I have copied the sheet down again and STILL get the problem. Excel version is 2002 at SP3, OPerating system is XP at SP2 - plus I beleive all the latest critical patches. Anyone else had this, or any suggestion on how to fix? -- It has only happened so far with Excel VBA -- All the Access one are still running 'break free'. Thanks David |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
stopping code | Excel Discussion (Misc queries) | |||
VBA code stopping in odd places | Setting up and Configuration of Excel | |||
Stopping Code | Excel Programming | |||
stopping code from looping | Excel Worksheet Functions | |||
Stopping Code from Running whilst in Loop... | Excel Programming |