ShowDetail Unable To Set The ShowDetail Property

[Lewzerrrr]

Hi,

I'm trying to test whether a group of columns is hidden or unhidden by grouping, if I was to use 2 statements such as Columns(2).ShowDetail = True and Columns(2).ShowDetail = False, it would open and close.. however when I try to test if one is True then False Else True it fails?

So if my column is hidden and my statement is:

            Colnum = ActiveCell.Offset(, -1).Column

                    If Columns(Colnum).ShowDetail = False Then


                    Columns(Colnum).ShowDetail = True
                    
                    Else
                    
                    Columns(Colnum).ShowDetail = False
                    
                    End If

It skips the first condition no matter what. Always going to the Else statement? How comes?

Thanks,

 

[Lewzerrrr]

Solved with this but still unsure as to why that doesn't work

            ColNum = ActiveCell.Offset(, -8).Column            
                If Columns(ColNum).Resize(, ColNum + 8).Hidden = False Then
                    Columns(ColNum).Resize(, ColNum + 8).Hidden = True
                Else
                    Columns(ColNum).Resize(, ColNum + 8).Hidden = False
                End If