It's almost good, but the clear contents line is giving me error because columns X and Y are merged.

Interesting that your first macro did not have this error, so I'm wondering if it is possible to clear contents using the logic in the first code?

Thank you!