What's the matter with this syntax? Can't I paste a single cell into multiple cells? This errors on "Application-Defined or Object-Defined Error"



Cells(1, 1).Copy Sheets("Pasted Zip Codes").Range(Cells(3, 1), Cells(3, 15))