Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Relative Ranges in excel macro | Excel Discussion (Misc queries) | |||
Relative Ranges in excel macro | Excel Worksheet Functions | |||
Excel macro that opens new MS Word file and pastes data as a pictu | Excel Worksheet Functions | |||
Button fails to call macro when open an Excel via Intranet | Excel Discussion (Misc queries) | |||
Macro in Excel 2002 to save a workbook to a FTP location | Excel Discussion (Misc queries) |