Hide and unhide certain rows with certain value

I timed it with the previous one and this one, they both take about 45 seconds (no difference)....
I dunno how long it takes on your computer, but compared to the (sample code) that I posted earlier, which takes about 10 seconds..... 10 seconds sounds a lot better.

I still think it may have to do with that "union" function... of course I'm no professional. Whatever it is, it's much faster. Maybe you can figure out what part of that (sample) code makes it faster?

Thanks again for your help!

Well, its still about 45 seconds... I guess it's my computer.... if that's the fastest it can go, then I guess I'll have to live with that...

Thanks for going the extra mile!

Hi, I would like to hide rows based on a cell value as well. I downloaded the example. I'm a complete technotard...but I'm learning. Basic question is, how do I get it to work in my workbook?

The workbook is a quote generator based on details provided in worksheets. What I would like is for rows to be hidden where values in column BA are $0. Then, if there are changes to the selection forms, like adding an item to the quote, I'd like to be able to hide/unhide so those items appear. Ideally, I'd like a button on the "Quote" worksheet to hide/unhide instead of having to go to VB and 'run' the program. The effected rows are in two sections...first section is rows 33 - 96. Second section is rows 102-165. Is this possible or am I asking to do too much? Clear as mud?

Thank you in advance for any assistance.

I think I figured it out. Thank you so much.

Hello Seifert, and welcome to the forum. Great to hear you figured it out but for your future posts please be aware of the following:

You have inadvertently broken Rule #2 of the forum rules.

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.

Rookie error.