Paste everything except conditional formatting

Originally Posted by CK76

Easiest method, paste everything including CF. Then remove CF from paste range.

Other than that, you can apply Formulas & Number Formatting paste, and then paste Comments only on top of it.

Thank you.

The first method is tedious. It creates dozens of conditional formatting rules in my cases.
The second method still misses. It misses the style formatting (eg cell color).
I have to paste a lot. It appears there is no good solution except a macro.

Oh, I thought you had base code doing copy paste, my bad.

But for us to help you more with code. You'd need to supply parameters of your copy paste operation.
Ex: is it within same sheet? to another sheet? Is paste destination always same? Is it paste to another workbook? etc etc.

As code can't accommodate for every use case, and I'm not a mind reader

Originally Posted by xladept

Try this:

Please Login or Register  to view this content.

It pastes at A1 which is undesirable. I would like it to place where my mouse pointer is.
It appears this will delete all conditional formatting rules in the destination worksheet.
I just don't want the conditional formatting rules of the copied cell ranges to be applied on the target worksheet.
Thank you.

Originally Posted by CK76

Oh, I thought you had base code doing copy paste, my bad.

But for us to help you more with code. You'd need to supply parameters of your copy paste operation.
Ex: is it within same sheet? to another sheet? Is paste destination always same? Is it paste to another workbook? etc etc.

As code can't accommodate for every use case, and I'm not a mind reader

It can be within the same sheet, or to another sheet in the same workbook.
It could be pasted in different locations in the sheet(s).

It does NOT paste to another workbook.
Please feel free to ask if anything is still not clear.
Thank you.