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
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