Excel - Range.Hidden property
Posted on 2001-07-30
I have got a problem with use of Range.Hidden property:
I put the ActiveX CheckBox on my sheet and assigned following procedure:
Private Sub CheckBox1_Click()
Columns(10).Value = "Abracadabra"
Columns(10).Hidden = True
The first line is OK (All fields in the Column No.10 are filled with "Abracadabra") whereas the second one fail (Error 1004).
Note that if I put these two lines for instance in Worksheet_Change event, everything is OK.