Re: Removing condition formatting using macro

2014-07-08 Thread Ariel Constenla-Haile
Hello João, On Tue, Jul 08, 2014 at 11:02:21AM -0300, "João Paulo R. Rezende" wrote: > 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) > myShe

Removing condition formatting using macro

2014-07-08 Thread João Paulo R. Rezende
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