Okay, the .PasteSpecial xlPasteValues worked, until I try to paste into cells that are merged. Is there a trick to get around that?