Range copy Excel crash workaround
Hi, ppl
My first post as a 1st time developer, so bear with me...
I've put together a very basic database. There is a form with a bunch of option boxes where the user can enter data and a set of comboboxes that filters the date column so the user can set a date range. The filtered data, defined as a range, is then copied over to another worksheet and the option box values are counted up. On a third worksheet, the reworked data is used to generate a set of charts.
Okay, simple enough, but here's the thing: any attempt at this point to save and close the workbook results in Excel crashing with the usual Microsoft rubbish about going online to find a solution. Except, and here's the workaround, if I delay saving and closing the workbook by 15 to 20 seconds, it exits normally, so I'm guessing that there is a thread or process that needs time to run its course.
Oddly enough, everything points to the range copy function described above as being the guilty party. If I step through the procedure or do it manually, everything works fine, it is only when the range copy is performed by VBA that everything goes wrong.
If anyone can throw some light on what's going on, I would be very grateful. Where this sort of thing is concerned, I hate mysteries.
In conclusion, I'm running Excel 2003, Office 2003 Service Pack 2, Vista HP on 2.4G Pentium Dual-Core with 2G of RAM.
Yours sincerely
Trevor
|
