That worked on what I setup to test with otherwise I wouldn't have suggested it.
It's unlikely I setup every thing the way you have it.
If you attach a sample workbook where this doesn't work and I'll check out what's happening.

If you remove does Excel indicate any errors ?

My apologies!! You are correct!

I forgot the first rule of working on a project someone else designed: MAKE SURE THEY DID EVERYTHING RIGHT!

The row I was using as my "test case" did not have the cells merged properly.

Problem solved! The Paste Special Formats code works!

And now that I've gotten deeper into user testing, I've come across another challenge. Maybe you can help me with that too???

The insert is copying and pasting the values. Ideally, the new row would be blank OTHER THAN THE FORMULAS (hence the c/p formulas code).

I'm just starting to research this one, so I may just stumble across the answer myself (in between every other fire I have to put out), but there's nothing like picking the brain of someone with experience when opportunity affords.

Thanks again!!!