Hide rows with bold text

[Ethan]

Hello all,

I'd like to hide rows that have text in bold in column N
The range is N26:N85

Is this possible?

[CodeNinja]

Ethan,
Try this:

[VBA]Sub test()
Dim i As Integer
For i = 26 To 85
If Sheet1.Cells(i, "N").Font.Bold = True Then Sheet1.Range("A" & i).EntireRow.Hidden = True

Next i

End Sub[/VBA]

[Ethan]

Wow, thank you CodeNinja!
Last question: How to use it for non-bold only?

[Ethan]

I tried .Font.Regular but that did not work

[Ethan]

Sorry for that it should be offcourse
Font.Bold = False Then...

[CodeNinja]

Good for you figuring that out!