Code to hide rows accross multiple sheets based on cell content.

[Mauro Arguello]

I need the macro code to hide rows on several sheets at once based on their content. Like if cell contains letter "U" hide that row... this in several sheets.

Thank You,

Mauro

 

[peachyp00]

Is the cell you need to check if it contains "U" all in the same column?

 

[Mauro Arguello]

Is the cell you need to check if it contains "U" all in the same column?

Yes, that whole column in all sheets have one of three letters, one is "U"

Thanks,

Mauro

 

[Mauro Arguello]

This is the code that I'm using but it only works on one sheet.

Sub LAonly()

Const LetterToHide = "U"

On Error GoTo Whoops

ActiveSheet.Unprotect "1"

Rows.Hidden = False

With Columns("o")

.Replace LetterToHide, "#N/A", xlWhole

With .SpecialCells(xlCellTypeConstants, xlErrors)

.EntireRow.Hidden = True

.Value = LetterToHide


Sheets("RENAL").Select

ActiveSheet.Unprotect "1"

With Columns("n")

.Replace LetterToHide, "#N/A", xlWhole

With .SpecialCells(xlCellTypeConstants, xlErrors)

.EntireRow.Hidden = True

.Value = LetterToHide

End With

End With

End With

Whoops:

ActiveSheet.Protect "1"

Sheets("PRESUPUESTO 2013").Select

End With

End Sub