Help to speed up code

[sintek]

Hi All

I have the below code that hides rows based on values and once prints, restores.
It is a wee bit slow...Can anyone please assist.

Please Login or Register  to view this content.

[JBeaucaire]

Maybe just hide the found rows all at once:

Please Login or Register  to view this content.

[YasserKhalil]

Hello. try this code

Please Login or Register  to view this content.

[sintek]

Hi JBeaucaire

Thanks for input. Works faster.

[sintek]

Hi YasserKhalil

Thanks for input.
I get a runtime error on following line:

Please Login or Register  to view this content.