Hide rows
Hi Gord,
Add William's unhide all rows to start(just in case) and we get....
I think that this is already covered by the existing else condition:
Else
rngCell.EntireRow.Hidden = False
End If
---
Regards,
Norman
I think tha
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Norman
Looking gooder all the time.
Hides rows if no cell in E through H is bolded.
Ignores all other columns.
Add William's unhide all rows to start(just in case) and we get....
Sub HideRows()
Dim rngCell As Range
With ActiveSheet
Intersect(.UsedRange, _
.Columns("E:H")).EntireRow.Hidden = False
End With
For Each rngCell In Intersect(ActiveSheet.UsedRange, _
ActiveSheet.Columns("E"))
If rngCell.Resize(1, 4).Font.Bold = False Then
rngCell.EntireRow.Hidden = True
Else
rngCell.EntireRow.Hidden = False
End If
Next
End Sub
Gord
On Tue, 6 Jul 2004 19:45:33 +0100, "Norman Jones"
wrote:
Hi Gord,
I think that this fails where there are no bold cells in a row's column
E:H
range, while there are bold cells in one other column(s) on the row.
Adapting your approach (which is more elegant than mine):
Sub HideRows()
Dim rngCell As Range
For Each rngCell In Intersect(ActiveSheet.UsedRange, _
ActiveSheet.Columns("E"))
If rngCell.Resize(1, 4).Font.Bold = False Then
rngCell.EntireRow.Hidden = True
Else
rngCell.EntireRow.Hidden = False
End If
Next
End Sub
---
Regards,
Norman
"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
Patti
You are testing each cell in the range. If any cell in column E
through H
is
not Bold, the row will be hidden.
Try this........
Sub test()
For Each rngcell In Intersect(ActiveSheet.UsedRange, _
ActiveSheet.Columns("e:h"))
If rngcell.EntireRow.Font.Bold = False Then
rngcell.EntireRow.Hidden = True
End If
Next
End Sub
Gord Dibben Excel MVP
On Mon, 5 Jul 2004 23:17:18 -0500, "Patti" wrote:
Can anyone explain to me why this doesn't work? I am trying to
filter a
sheet so that I am only viewing rows that have a bolded cell anywhere
in
columns E:H. The code is hiding all rows in the worksheet.
Sub test()
For Each rngCell In Intersect(ActiveSheet.UsedRange,
ActiveSheet.Columns("e:h"))
If rngCell.Font.Bold = False Then
rngCell.EntireRow.Hidden = True
End If
Next
End Sub
Thanks in advance.
|