Thread: delete conditional formatting via macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Wigi Wigi is offline
external usenet poster
  
Posts: 396
Default 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

Reply With QuoteReply With Quote