Require faster Macro Code

[wiehan]

Hi Formum,

I am pretty new to this Macro code stuff. I have a Macro code for a command button on the worksheet(seen below) that hide rows depending on a certain condition. The code works fine, but only if you have a couple of rows, I have 10003 rows it must look through and then hide the relevant rows. Now this will take some time to go thru all these rows and then hide the relevant ones. Is the a code that wil work faster?

Thank you for the answer in advance.

Please Login or Register  to view this content.

[mikerickson]

One way would be

Please Login or Register  to view this content.

[Cutter]

@wiehan

Hello, and welcome to the forum. Please take a look at the forum rules. You've inadvertently broken 2 of them already (#3 - code tags and #5 - duplicate posts).
I've added the code tags for you this time but please remember to add them yourself to any code you show in your future posts. Also, I have closed the other, duplicate thread.