Optimizing code speed: Hiding rows with loops - looking for faster way

**Taktiker** · 10-24-2012, 06:16 PM

Hello!
The following code hid the rows of the listed cells if the cell does not contain anything if I click on the checkbox in my sheet and unhides them if I click again. The problem is that it needs about 5 to 7 seconds for the rows to disappear and I would like to have it faster. Does anyone have an idea how to get the same result faster? Without that many loop stages?

Please Login or Register  to view this content.

Greetings,
Taktiker

**Norie** · 10-24-2012, 06:28 PM

Try this.

Please Login or Register  to view this content.

**Taktiker** · 10-27-2012, 02:56 PM

My this is awesome! From 6-7 seconds to 0,1 seconds. Unbelievable.

Thanks

**Taktiker** · 10-27-2012, 03:04 PM

Actually, I have another code: Its the second rowhiding and is intended to hide the capture-rows. It is essentially a similar code, but a bit different. Dont be scared by its size, its just the same 9 times for 9 rows. I didn't see a way to use the union thing, so my question is: Is there a way to optimize it? So its so super fast, too?

Please Login or Register  to view this content.

**Taktiker** · 10-27-2012, 05:08 PM

bump, bc its already on the end of page 2

**SuitedAces** · 11-04-2012, 11:15 PM

You could name the ranges to simplify your code.
For example...

Please Login or Register  to view this content.

You can delete it after you run it

Then reduce your original code to...

Please Login or Register  to view this content.

Let me know if it works as intended, I only did a partial test

**Taktiker** · 11-07-2012, 04:24 PM

Application.ScreenUpdating = False & True already fixed the problem. It does essentially what I wanted, not showing the calculationstuff and needs less time. Thx!