delete conditional formatting via macro
 

Hi,

Is it possible to remove conditional formatting setting vai a macro.

I use a macro to copy a range (visible rows only) to a new sheet, the
cond.formatting gets messed up because the row numbers change.

The macro recorder doesn't record the cond.format part.

Cheers,

Harold

delete conditional formatting via macro
 

For instance

Selection.FormatConditions.Delete


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"mohavv" wrote:

Hi,

Is it possible to remove conditional formatting setting vai a macro.

I use a macro to copy a range (visible rows only) to a new sheet, the
cond.formatting gets messed up because the row numbers change.

The macro recorder doesn't record the cond.format part.

Cheers,

Harold