Same Button to show/hidden Range("NamedRange")

[crun2075]

Hello there, I've been trying to make a button to show Rows/Columns A1:C3 with named range test with one click then hide it with another click of the same button.

I can achieve this by using the rows(1:3).hidden but when using the Range("test").hidden it returns a error. Any help would be grateful.

 

[Fluff]

How about

   With Range("Test").EntireRow
      .Hidden = Not .Hidden
   End With

 

[crun2075]

That worked great thank you very much!

 

[Fluff]

You're welcome & thanks for the feedback.