Pasting a formula and it works for some but not all cells

what is in those merged cells? Are they part of what you're trying to copy? If so, that could be the difficulty....merging cells is generally not a good practice while you're still developing a workbook. It's fine (though potentially problematic) if you're at the final stage and just doing it for a "nice looking" report, but try to avoid merging prematurely.