Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Muttley
 
Posts: n/a
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Relative Ranges in excel macro edself Excel Discussion (Misc queries) 6 October 13th 05 02:02 PM
Relative Ranges in excel macro edself Excel Worksheet Functions 6 October 13th 05 02:02 PM
Excel macro that opens new MS Word file and pastes data as a pictu Rob Excel Worksheet Functions 0 July 6th 05 05:12 PM
Button fails to call macro when open an Excel via Intranet tigertax Excel Discussion (Misc queries) 1 April 12th 05 10:21 AM
Macro in Excel 2002 to save a workbook to a FTP location Lloyd Excel Discussion (Misc queries) 0 December 21st 04 02:49 PM


All times are GMT +1. The time now is 01:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"