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