Hello,

I want to create a macro to remove or clear all condition formats in current sheet.

I had tried:

myRange.ConditionalFormat.Clear()
myRange.ConditionalFormat.removeByIndex(index)
mySheet.ConditionalFormat.Clear()

Already tried,
Dim oPropCondition As Object
.....
oPropCondition = oRange.ConditionalFormat
oPropCondition.Clear()
oRange.setPropertyValue( "ConditionalFormat", oPropCondition)

But nothing works,

How can I do this?

Thanks in advance,

--
João Paulo

Reply via email to