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 quot;97-2002 amp; 5.0/95quot; 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.
- Nov 21 Wed 2007 20:40
Excel closes down during a macro
close
全站熱搜
留言列表
發表留言