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!!!