Condititional Formatting Range Address

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

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
 
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
 
Back
Top