On Thu, 9 Apr 2009 20:30:24 +0100, "RB Smissaert"
wrote:

Two things here.
Firstly, when your workbook is that big you are probably better off with
storing the data
away from Excel, maybe in a database such as SQLite.
Secondly, you need to clean your code from time to time with a code cleaner:
http://www.appspro.com/Utilities/CodeCleaner.htm

RBS

I'll try that and thanks for the tip. Yes I have much redundant code,
some of it temporary which I don't delete, in case it's wanted again.
But the problem arises when I save the xls, not when (my) code is
executing.
Would rather not have a seperate front/back end, but if that's what
is causing the crashes....

Cheers - Kirk