VBA, hiding cells or hide rows!

Morning, Me again. confusing myself again. either that or asking vba/excel to do too much


I have two drop down boxes on a worksheet.

C1 drop down contains - "Handler, Team, Both".. and the following code in VBa works behind it

Please Login or Register  to view this content.

And i Also have C3 with months of the year with the following working behind it

Please Login or Register  to view this content.

The problem is I cant get them both to work on the same vba.

If i put the code individually it works fine. Put them together and they don't work.

I Do want them to work together so if they select Handler, Jan. It hides Feb-Dec and Team data.


can i put them as seperate subs to work, or is there something im missing?

I'm hoping its a simple fix rather than a "if C1=Team and C3="Jan" hide E8:O21 or something similar


Thanks

apologies for thread (and be blown up if needed)..


I have been playing around a lot more and i "seem" to have it working for now. Not sure what I did different.