InsertLines crashes Excel
I am writing code that adds a CheckBox to a worksheet with a Click event
handler in the worksheet code module.
The problem is that the InsertLines method crashes Excel with a "Automation
error Exception occurred" message.
This happens whether my virus scanner is enabled or disabled. It also
happens on a different machine with no virus scanner. It happens identically
in Excel 2002 and 2003. But oddly, it does not happen every time I use
..InsertLines. Sometimes it works fine.
Any ideas why Excel might be crashing?
Thanks,
Andy
|