M
Muttley
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.
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.