Condititional Formatting Range Address
 

I have a Worksheet with conditional formattting
on it. Is there a VB method to determine the
range used by the conditional formattting? There
are no named ranges that I can find.

Thanks in advance,
Jim

Condititional Formatting Range Address
 

Perhaps:

Dim rng as Range
On Error Resume Next
set rng = Cells.SpecialCells(xlCellTypeAllFormatConditions)
On Error goto 0
if not rng is nothing then
rng.select
End if

--
Regards,
Tom Ogilvy


Jim wrote in message
...
I have a Worksheet with conditional formattting
on it. Is there a VB method to determine the
range used by the conditional formattting? There
are no named ranges that I can find.

Thanks in advance,
Jim

Condititional Formatting Range Address - Thanks Tom
 

On Mon, 29 Sep 2003 19:09:04 -0400, "Tom Ogilvy"
wrote:

Thanks Tom I will give it a whirl.

Jim


Perhaps:

Dim rng as Range
On Error Resume Next
set rng = Cells.SpecialCells(xlCellTypeAllFormatConditions)
On Error goto 0
if not rng is nothing then
rng.select
End if