excel 2000 faster than excel 2003

C

chanteclair

Joined
Apr 16, 2007
Messages
1
Reaction score
0
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
Fill Color Macro 5
worksheet_change colour of a row on change of cell 15
Changing up to 2 of 3 vals and the 3rd val is automatically Calcul 4
Identify Hidden Columns - New issue! 19
converting a for next loop into a for each loop 2
hide zero rows / shadwe every other visible 1
I need help with macro 3

Top