Autohiding duplicates then unhiding again.

Hello all,

I am looking for a vba, or macro that will autohide all rows after a freeze pane except for the last row of a set of duplicates.

I am looking to attach this vba to a button on the spreadsheet so, I would like the user to push the button to hide everything and then the user would push the button again to unhide everything.

I hope this makes sense. I have been looking for something like this all over the place but everything is all about deleting these rows and that is not what I am wanting.

If I need to attach a workbook with before and after I please let me know.

Thank you all in advance for your help.

Here's the code:

Please Login or Register  to view this content.

I've already attached it to a button for you on the Before sheet. I also streamlined some of your other macros...compare my version to your original to see how much extra dross is added by the macro recorder that you can tweak out later.

Hey JB,

Thank you so much for your help. Your code works perfectly. I even decided that instead of hiding I would rather delete the extra rows, and I figured that out for myself!!! Yeah! LOL.

But, when I copy the code over to my main spreadsheet I get an error that I need to debug.

I've tried on my own and I'm not having any success. Boo! LOL.

The line of cod e that highlights yellow when I click on debug is:

Please Login or Register  to view this content.

When I put my curser over it it says:

Please Login or Register  to view this content.

Any idea on what I am doing wrong?

Also, I am not putting a button on the spread sheet anymore, I'm adding a button on the toolbar. Would that have anything to do with it.

Thank you so much for your help. I'm trying to self educate myself with a VBA for Dummies book but I am and probably will never be close to your knowledge.

Thank you so much for your contribution.

Originally Posted by whatsmyname

Any idea on what I am doing wrong?

There must be a substantive difference between the sample workbook and your main workbook. My code is using column H from row 5 down to spot all the cells with data and those that are blank. That's key to how everything else works.

If you can't adjust the code for a workbook markedly different from your sample, post your main workbook. Desensitize it, but leave the format the same.

Heh... the problem jumped right out at me, your first "section" is only 1 row, so I need to add a test for that...there's nothing to "hide" in that section. Update this section:

Please Login or Register  to view this content.

Here is the complete code for anyone who needs it:

Please Login or Register  to view this content.

And for anyone looking for something like this but you need the rows deleted:

Please Login or Register  to view this content.

Thanks again JB!!

You should probably change the name of the second macro.