How do i speed up my hiderows code?

Hi all

I use the following small piece of code to hide rows based on whether the value in the Range is an 'x'.

Please Login or Register  to view this content.

The problem is it takes so looooong to work through the worksheet and hide the required rows! Is there anything I can do to speed this up? I was hoping it would work faster (ideally as fast as a filter would take). The actual range of the data table in question is from C17 to AC172, so could the code be amended so it doesn't have to go through each entire row?

Thanks for any help on this

Kenny

Hey,

you shouldn't loop through the rows one by one, instead hide the whole range at once.

upload a sample workbook

Regard
CA Mahaveer Somani

Here is a procedure that does something similar, not sure if this is exactly what you need though.

Please Login or Register  to view this content.

hi RHCPgergo

I'm going to give your code a go but i don't want to delete the rows just hide them (so they can be unhidden later if required), sorry but how do i amend your code to do this please?

Thanks
Kenny

Oh, sorry. Just change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

i did think it was that and the code wasn't working, but since just realised i'd not included another line of the code by mistake, so thanks very much for your help! it's much faster using this method, i'm not familiar with the union command in VBA so thanks for pointing this one out to me

Kenny