Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete Method as it applies to format Condition object
I am trying delete conditional formats for a specific range of cells. The
Help documentation all say to use the Delete Method to delete a formatcondition but I do not see a specific delete method for Format conditions. Here are some instances I have tried but all generate errors. With Worksheets(TargetWS).Range(Cells(5, 5), Cells(TargetRw, 5)) .DeleteFormatConditions (1) .DeleteFormatConditions (2) .DeleteFormatConditions (3) End With or Worksheets(TargetWS).Range(Cells(5, 5), Cells(TargetRw, )).FormatConditions (1).Delete Does anyone know the syntax for using the Delete Method to delete conditional formats (Format Conditions)? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Method "Method 'Open' of object 'Workbooks' failed | Excel Programming | |||
Sum of data where a condition applies | Excel Discussion (Misc queries) | |||
How to create a Delete method which frees memory occupied by my object | Excel Programming | |||
"Delete" method of a worksheet object | Excel Programming |