What are possible causes of VBA clearing Conditional Formatting

[philwojo]

Hello, I have several version of a workbook I am trying to implement, as I've added and changed code I've saved in different revisions.

Right now I am trying to track down why Conditional Formatting is being cleared from one range of cells on a newer revision of the WB compared to an older revision.

I am trying to compare changes I've made, but can anyone tell me what some common causes would be to look for that could cause CF to be cleared from cells?

I do use Clear.Contents in several parts of my code, and I checked to make sure it is not just a Clear, and I can't find code that would indicate that anywhere.

I'm looking at all of the other code I have put in and had help with and I'm just not seeing anything that should be causing this, but I know I could easily be overlooking something.

Any help would be greatly appreciated.

I know I could post all of my code, but I'm holding off on doing that for now, unless someone requests me to do that.

Phil

 

[philwojo]

Thank you all for your assistance.

I now see why this was overwriting the CF I had on that other, and I appreciate the assistance with the code.

I have worked with the .PasteSpecial before, but I'm still tyring to learn VBA better and it just wasn't clicking today (and last night).

I appreciate your patients, as always, and am grateful for your help.

Phil