BOLD CELLS FILTER - VBA "Please Help?!?"

[Teddy-B]

I need the VBA to filter a range of subtotales by BOLD type. I want to write
this command into a macro. I have always used Ron deBruin's easy filter, but
the easy filter will not allow itself to be written in as VBA, even if the
Add-In is embedded into my excel program. I know that there is simple VBA
language that will aloow me to filter my sub-totaled column by BOLD type.
PLEASE HELP

PS. "Mike H - Please do not respond with the generic helper cell/answer
found at http://support.microsoft.com/default.aspx/kb/213923." This is not
useful for VBA with sub-totaled cells.

THANKS and please hurry!

 

[Shane Devenshire]

Hi,

Here is some code

Sub FilterBold()
Dim cell As Range
For Each cell In Selection
If cell.Font.Bold = False Then
cell.EntireRow.Hidden = True
End If
Next cell
End Sub

 

[Ron de Bruin]

Hi Teddy

I use AdvancedFilter in the Add-in to do the filter
and use a lot of code<g>

I will put it on my list to create a simple example