I'm looking for a way that will hide row "I" if range: QTYCALCON is shown.
So far I came up with this.
Sub Hide_Show() With Range("QTYCALCON").EntireColumn .Hidden = Not .Hidden End With End Sub
I assumed "I" was a column and you want the code to work both ways depending on which column is hidden. So, here is the code I would use.
Each time you run it, it will check to see if "QTYCALCON" is hidden. If not, it will hide "I". If "QTYCALCON" is hidden, this will unhide "I".
That should be rather posted in Stack Overflow. However, here it goes for hiding column