Hide rows in EXCEL

M

Marc H.

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
 
M

Mike Glen

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.

Mike Glen
Project MVP
 
M

Marc H.

Sorry Mike, and thankx for the info.
Marc
Mike Glen said:
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.

Mike Glen
Project MVP
Click to expand...
 

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

Hide rows in EXCEL 5
VBA - exporting serial letters to single documents 0
Excel VBA Macro to do this? 19
Word macro that can call cells out of Excel for a find and replace 0
Merging from an Excel file with graphics 1
Excel does not accept text format! 0
Hide rows in table based on 1 empty cel of the same row. 1
removing empty cells in a rows of data 0

Top