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