Unhide a row when you filter

[ndjustin20]

I have a question about showing a row once you filter something. Say I filter and it hides rows 2-7 and shows the results we'll say 8-23. Is there a way to force show say rows 2-4. I tried using Rows("2").Hidden = False after the filter though this didn't do it. Thank you in advance for your help

Justin

 

[Gary McMaster]

Try like so:

ActiveSheet.Range("2:4").Rows.Hidden = False
ActiveSheet.Range("6:6").Rows.Hidden = False

Gary

 

[ndjustin20]

AAAAAAAAAAAAAAAAAAAAAAAAA HAHAHAHHAHAHAHAHAH OMG!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! What I had worked Rows("2").Hidden = False......I put it in the wrong function Thank you very much for you response I really appreciate your time and I need to start using the full syntax as you provided

Man I tell you....sometimes it's the simple things when you are trying to figure out why something isn't working