I have a worksheet that has conditional formatting, I am trying to remove the conditional formatting, run some code, then restore the conditional formatting to the state it was in prior.
Something like:
Is this possible, and how to do it?
Something like:
VBA Code:
Dim wsGroom as worksheet
Dim fc as FormatConditions
Set wsGroom = Activesheet
...
Set fc = wsGroom.UsedRange.FormatConditions
Call deleteAllConditionalFormattingOnWorksheet(wsGroom) 'This works fine and deletes all conditional formatting on the worksheet
... Do stuff ...
Set wsGroom.UsedRange.FormatConditions = fc
...
Is this possible, and how to do it?