Slow Code, Can it be improved on?

[ptmuldoon]

Again, I'm still learning and reading some books so the below may not be the best approach or perhaps there is a way to speed it up.

The below is to hide and unhide various rows and columns based on a cell value of "Yes" or "No". And I've found the macro may take upwards of 20 seconds to run some times and unsure if it can be improved on.

I did abbreviate/shorten the below to post. But the macro searches various select ranges from A1 to about cell FF300. The word "Yes" and "No" could also be in other parts of the spreadsheet as well, thus I am searching the various specific ranges.

Please Login or Register  to view this content.

[watersev]

hi ptmuldoon, try sort of that

Please Login or Register  to view this content.

[ptmuldoon]

Thanks, but I think that did not quite do exactly the same thing. The original code is hiding either entire rows or entire columns depending on what a Cell says in that row or column.

I think your code just tried to hide all the columns where a yes was found. I will play with it some more tonight as well. Hopefully we can work to speed up the macro to hide them faster.

Your code is beyond my current skill set. But I will try and digest it and see what I can learn.

[watersev]

I did miss that point, then it might be done this way:

Please Login or Register  to view this content.

[ptmuldoon]

A HUGE thanks. The code seems to work perfectly and I'm adding in the rest of ranges needed.

And it WAY faster. And the code is called when the file opens as well, so was important to try and get it run quicker.