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: 50
Default Hiding rows - Excel 2000, 2002 vs 2003

Dear All,

Could anyone please tell me why the following code is running instantly in
Excel 2000 and 2002 but takes minutes in Excel 2003. The named range
Countries is only a little bit more than 40 rows.

Sub Mask_Countries()
Application.ScreenUpdating = False
ActiveSheet.Unprotect
ActiveSheet.DisplayPageBreaks = False

For Each c In [Countries].Cells
If (c.Value) = Empty Then
c.EntireRow.Hidden = True
End If
Next c

ActiveSheet.Protect
Application.ScreenUpdating = True
End Sub

If I turn the automatic calculation off in Excel 2003 it runs a lot faster
but not instantly as in Excel 2000 and 2003.
--
Regards,

Martin
 
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
hiding even (or odd) rows in excel 2003 9d1awd Excel Discussion (Misc queries) 5 February 2nd 07 06:25 PM
Recalculation on hiding rows in Excel 2003 Cantoris Excel Discussion (Misc queries) 1 December 4th 06 02:12 AM
Simple Macro, works in Excel 2002, 2003 but won't work in 2000 DJA[_2_] Excel Programming 5 September 28th 05 05:10 PM
Using OWC VBA programs in excel 2000/2002/2003 [email protected] Excel Programming 0 August 23rd 05 10:04 AM
Can you use excel 2003 version with excel 2002 and 2000 on a netw. cct Excel Discussion (Misc queries) 1 January 19th 05 12:11 AM


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