Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
=HYPERLINK("#"&CELL("address", ADDRESS(MATCH(VALUE(B3),Range ... ? | Excel Worksheet Functions | |||
How to create a range address with ADDRESS function? | Excel Worksheet Functions | |||
Condititional Formtting a Column | Excel Worksheet Functions | |||
condititional formatting! | Excel Worksheet Functions | |||
Deleting Range name's listed in the range address box. | Excel Discussion (Misc queries) |