Hiding a Row based on Cell Value

[Boykickscar]

Hi there,

I have a series of checkboxes linked to cells in a row (A2, B2, C2 etc. up to U2) and if a check box is ticked then the corresponding cell = "True", if the box is not ticked then = "False"

What I'd like to do not is use the call values of "True" or "False" to Hide/Unhide Rows (starting at Row 7 then going down to Row 28).

so True = Unhide, False = Hide.

I have no clue how to do this and would be grateful of any help.

Thanks

 

[Scott T]

Try

Sub hidetruefalse()
For i = 1 To 21
If Cells(2, i) = True Then
    Columns(i).EntireColumn.Hidden = False
    Else
    Columns(i).EntireColumn.Hidden = True
End If
Next i
End Sub

 

[Boykickscar]

Hi,

I've copied as it without luck. Do I need to change any of the values in the code?

Thanks again.

 

[Scott T]

You should not have to change anything. What happens when you run the code?

 

[Boykickscar]

It runs with any debug errors, but then nothing happens within the worksheet itself :S

Apologies if I'm missing something obvious.

 

[Boykickscar]

*Without any errors.

apologies.

 

[Scott T]

Are you running the code with the sheet with the TRUE/FALSE in row 2 as the active sheet?

 

[Boykickscar]

ah ok... I see what the issue is. I need it to hide rows rather than columns.

Thanks

 

[Boykickscar]

here's what I've done to amend the code for Rows;

Sub hidetruefalse()
For i = 9 To 29
If Cells(2, i) = True Then
    Rows(i).EntireRow.Hidden = False
    Else
    Rows(i).EntireRow.Hidden = True
End If
Next i
End Sub

however it doesn't matter what checkboxes are ticked or unticked rows 23-29 are always hiding.

any thoughts?


Thanks