Faster way to hide rows when cell equals zero

**thecubsfan15** · 06-13-2013, 03:01 PM

Hello!

I need some help. I have written a macro that will hide rows if a cell equals 0. The range of cells in which the macro looks at to see if each cell equals 0 is EE1495:EE3033. The problem is, it takes too long for the code to process completely. It takes around 2 minutes for the proper rows to be hide. This is the code I have written:

Please Login or Register  to view this content.

I heard that if you use an autofilter that it will go much faster but I'm not sure how to do that. And if that's not the fastest way to do it then what is?

Thanks to everyone that helps out!

**judgeh59** · 06-13-2013, 03:10 PM

howdy and welcome to the forum.....try this...

change range to yours....change field to 135 and change creteria1 to "0"

Please Login or Register  to view this content.

**Mordred** · 06-13-2013, 03:22 PM

It would probably be quicker for you to manually autofilter the 0s out.

**thecubsfan15** · 06-13-2013, 03:29 PM

This is a report. And a macro is important to condense printing space. If I use an autofilter manually then the style with changed.

judgeh59, I'm not sure where to put this in my code. Can you show me how you would write the entire sub?

**judgeh59** · 06-13-2013, 03:31 PM

sure....can you update a snippet of data (cleaned up, of course) and that'll make it easier....thanks

**krabine** · 06-13-2013, 03:37 PM

I remember a post in here that used a specialcells(xlblanks) to hide zero rows. He converted the 0 to a blank and then hid all of them which was incredibly quick. I just can't seem to find that post.

**thecubsfan15** · 06-13-2013, 03:40 PM

Item Plan Qty Unit
demolition 0 LF
Demo demising 1 LF
. . .
. . .
. . .

If the Plan Qty equals zero then it will hide that row. This is 1500 rows long.
Is this what you asked for? Sorry if it's not, I'm new here.

**judgeh59** · 06-13-2013, 03:50 PM

give this a try....

**thecubsfan15** · 06-13-2013, 04:03 PM

It seems to work in the example. But, It only leaves the values that are zero. I want it to filter out the 0 values.

**judgeh59** · 06-13-2013, 04:05 PM

I guess I need to see the actually data....can you clean up the company confidential stuff and upload the file....even part of it would help....something else is happening....