On Apr 28, 2:49*pm, Excel Help!
wrote:
I have created a macro to copy data from a worksheet; create a new worksheet
and paste the data. *However, the new worksheet has conditional formatting;
when I run the macro it deletes the worksheet along with the conditional
formatting. *Is there a way to append the new data and maintain the
conditional formatting in the new worksheet so I don’t have to re-enter the
conditional formatting? Thanks in advance for any help.

Could you just pasteSpecial(XlVlaues)? that way you keep the
formatting.

Jay