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!

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


--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Teddy-B" wrote:

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!

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Teddy-B" wrote in message ...
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!