Hide rows in EXCEL

Hi Folks,



I`ve got a little problem in excel and VBA.



I´va to check more then 5000 cells if they are empty or not. In case they
are empty I want to hide the row.



Here my is code:



for z = 1 to 5000

a = Cells(z, 1)

If a = 0 Then
Rows(t).Hidden = True
End If

next z



It´s running well but to slow.



Does anyone of you knows a better quicker way?



thanx a lot.



Marc

Hi Marc,

This forum is closing down. Anyway, these newsgroups are specifically for
matters dealing with Microsoft Project. I suggest you try to find a more
appropriate newsgroup that deals with Excel/vba problems.

Sorry Mike, and thankx for the info.

You're welcome, Marc, no problem :-)