LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Excel 2002 - Slow macros

Hi All

I am working on a spreadsheet where if a cell doesn't
match a date range the whole row is deleted. The macro
created worked fine in Excel97. However, it can take
anything up to an hour and a half for the macro to
process now. I have tried turning of page breaks, screen
update and automatic calculations but have no luck. Is
this a bug within Excel and is there a work-around?
 
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
Excel (2002) slow after deleting some macros Peter[_14_] Excel Discussion (Misc queries) 0 April 18th 10 09:06 PM
Calculations run slow in Excel 2002 SP-1 Ash Excel Discussion (Misc queries) 1 August 14th 06 08:13 PM
Saving very slow in Excel 2002 Ailish Excel Discussion (Misc queries) 3 September 23rd 05 07:27 PM
Why are subtotals so slow in Excel 2002 SP-2? Confused? Me too! Excel Discussion (Misc queries) 1 January 27th 05 04:28 AM
DDE very slow with Excel 2002, 2003 Alexandre Nikolov Excel Programming 0 December 23rd 03 12:59 PM


All times are GMT +1. The time now is 08:35 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"