Macro Filter to hide rows based on Drop Down List

I am trying to create a macro that will auto filter but nicer. Based on a specific cell drop down list (cell H4). But there are headings that I do not want hidden no matter the value i nthe drop down list. My code is below:

Please Login or Register  to view this content.

I am getting an object error. My logic is that first the macro will hide all non-heading lines, as they don't have anything in column B, then unhide all the rows where the column D valuse match cell H4. Can this work this way? I can post the excel if necessary. Thanks

Any ideas on this. Any other ways to do this? Thanks.

Attached is an example of what I want to filter. There is the drop down list towards the top that I want to trigger the action, but I can add that later. I would just like to be able to have someone change that cell, then all of the other tasks without there name are hidden, leaving their tasks and all of the project headers.

Well, after I posted the example, I solved it. Basically I created formulas in one column to change corresponding to a designated cell in that row. So when the two match, the forumla = 1, when they dont, = 2, and when the drop down list is blank, everything ='s 3. Then I set the macro to run when the drop down list is changed. Macro is the following:

Please Login or Register  to view this content.

it is pretty simple, and kind of slow, but this excel is for project management, and right now the projects should not be getting to 1,000 tasks. Either way it works for now and this is SOLVED!