I've got a worksheet in one workbook that I want to paste into a blank
worksheet in another. I've tried selecting the whole worksheet, then
Copy, etc, tried selecting only the particular cells I want, then
Copy, etc, I've tried Paste, Paste Special, All, Formats, Formulas,
the lot. But it still won't paste all the formulas nor all the
formats in, only some, as far as I can see. I've got both worksheets
open in the 'same' Excel, ie I haven't got Excel open twice (it won't
do it at all then). Any answers?