Excel closes down during a macro
 

I have a spreadsheet (with macros) that works fine when I run it through XP.
However when it runs in NT it will just disappear halfway through a macro,
with no save/excel not responding warnings and no error messages. I have run
through the macro step by step and it seems to fall over when copying some
filtered data from one sheet to the next (which doen't seem too unusual a
command!)

I have saved the spreadsheet as a "97-2002 & 5.0/95" spreadsheet and doubt
I've used any functionality that didn't exist in pre-95 versions (as my VB
knowledge is limited!)

It is filtering on 40710 rows of data, and I have had problems in the past
with copying large ranges of filtered data before - does 5.0 have more power
to do this than pre95? However some kinda error message came up when this
happened.

Any help would be appreciated. Thanks.