Hi guys,

What I am trying to do is similar to the Copy| Paste Special >> Values functionality...

but instead I want to Copy | Paste Special Formats... but not have the underlying Conditional Format formula...

Basically, I used conditional formatting on my sheet and it covers a large range...so it slows my sheet down dramatically...

I just want the background colours and fonts to stay, but not the CF formula...

Does anyone have a small piece of code that can accomplish this?

Thanks much.