excel 2000 faster than excel 2003

F

fred

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Selctionner la derniere ligne et collage special 1
click event problem in excel 2003 only 0
Change row colors based on a cell value 1
Fill Color Macro 5
Identify Hidden Columns - New issue! 19
Macros Issue 2
converting a for next loop into a for each loop 2
Print Directory to Excel 13

Top