Excel crash when running macro
I have just started having a similar problem using Excel 2003 in Windows XP.
I am using the control toolbox to make list boxes which simply pull the list
from another spreadsheet and then send the pick result to a cell on that
sheet. It almost seems random, except it happens about every 10 minutes. I
did not notice this problem until I installed a recent service pack for MS
Office. I tried turning off calculation while I am editing the controls, but
that does not seem to help. This is frustrating because Excel wipes the file
clean of VBA code as it crashes Excel.
"Eamonn" wrote:
Hi, I keep getting a crash in Excel when I try running some macros I
have, the basic format is find something in one sheet, try and find in
another workbook (so open a file), if not there, replace. Obviously
there is a good deal more complexity than that, but that is the
general idea.
I keep getting the following:
The instruction at '0x308e0b79' referenced memory at '0x03add000'. The
memory could not be read.
Is this a problem with my code, or Excel, I found a few things that it
might have been and changed those but still experiencing the problem.
Any ideas. Thanks
Eamonn
|