Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel 2000 faster than excel 2003
hello
I create a program - macro with excel 2000 It hdes certains rows with certains criterias it works very fast with 2000 rows (4 seconds) when i try with excel 2003 it goes slowy slowly 4 minutes !! do you have an idea I use this kind of command If (Feuil.Cells(Ligne, 6).Interior.ColorIndex = xlNone) Then If BoutonCPTEE.State = msoButtonDown Then Feuil.Rows(Ligne).Hidden = True Else Feuil.Rows(Ligne).Hidden = False End If End If If ((Feuil.Cells(Ligne, 6).Interior.ColorIndex = 15) Or (Feuil.Cells(Ligne, 6).Interior.ColorIndex = 48)) Then If BoutonRef.State = msoButtonUp Then Feuil.Rows(Ligne).Hidden = True Else Feuil.Rows(Ligne).Hidden = False End If End If If ((Feuil.Cells(Ligne, 6).Interior.ColorIndex = 37) Or (Feuil.Cells(Ligne, 6).Interior.ColorIndex = 34)) Then If BoutonCPT.State = msoButtonUp Then Feuil.Rows(Ligne).Hidden = True Else Feuil.Rows(Ligne).Hidden = False End If End If |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening files in Excel 2003 saved in Excel 2000 without data loss... | Excel Discussion (Misc queries) | |||
Excel 2000 and Excel 2003 in Office 2003 | New Users to Excel | |||
Upgrade from Excel 2000 to Excel 2003 without MS Office 2003? | Excel Discussion (Misc queries) | |||
Problems using Excel 2000 to open/save file saved in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2003 crashes loading excel files created Excel 2000 | Excel Discussion (Misc queries) |