Auto hide fields using macros in MVB

[Fmedia]

Hi

I am in urgent need of some expert advice. I have a spreadsheet file that has several other dependencies, and looks very messy, as a lot of the cells are redundant (with FALSE in the cell because they are irrellevant). What I want to do is automatically hide any rows with 'false' in it. I have created in Microsoft Visual the following Macro:

Sub HideRows()

If Sheets("Sheet2").Range("A13").Value = False Then
Sheets("Sheet2").Range("A13").Select
Selection.EntireRow.Hidden = True
End If

End Sub

This works for what I want it to do, however is specific to one row (ie a13). When I want it to remove all false cells the macro wont work. I have tried the range "A:A", "A,A" and several more but to no avail. Can anybody help.
Many Thanks
Jonathan

 

[SteveO59L]

Are your "False" entries always in Col A ?

 

[Fmedia]

Hi,
Thanks for responding.

yes, col A is the master field so 'false' will always return in here if not relevant.

Jonathan

 

[SteveO59L]

Dim c As Range, rng
Set rng = Range("a1:a30")
For Each c In rng
If c.Value = "False" Then
c.EntireRow.Hidden = True
End If
Next c

 

[Fmedia]

Cheers SteveO59L

Worked a treat

Jonathan