I have a very large workbook that I have to copy parts of into a separate workbook a couple times a month. This has always worked with copying a range in the source workbook then selecting one cell in the destination workbook and 'paste.' However, now when i try to click in one cell in the new workbook and paste, i get the following error message:
You can't paste this here because the copy area and paste area are not the same size.
Select just one cell in the paste area or an area that's the same size, and try pasting again.