Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
hiding even (or odd) rows in excel 2003 | Excel Discussion (Misc queries) | |||
Recalculation on hiding rows in Excel 2003 | Excel Discussion (Misc queries) | |||
Simple Macro, works in Excel 2002, 2003 but won't work in 2000 | Excel Programming | |||
Using OWC VBA programs in excel 2000/2002/2003 | Excel Programming | |||
Can you use excel 2003 version with excel 2002 and 2000 on a netw. | Excel Discussion (Misc queries) |