Strange Copy/Paste behavior
 

Hello -

I've never seen this one before ...

Excel won't allow me to copy a range from one sheet and paste on
another (within the same workbook)! I can copy the selected range,
but when I switch sheets, it's as if the CutCopyMode changes to False
or something.

Anyone ever seen this? Know how to fix it?

TIA,
ray

Strange Copy/Paste behavior
 

Are you copyingthen creating the sheet?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ray" wrote in message
ups.com...
Hello -

I've never seen this one before ...

Excel won't allow me to copy a range from one sheet and paste on
another (within the same workbook)! I can copy the selected range,
but when I switch sheets, it's as if the CutCopyMode changes to False
or something.

Anyone ever seen this? Know how to fix it?

TIA,
ray

Strange Copy/Paste behavior
 

I did do that initially (copy - insert sheet - 'error') but
afterwards, copy/paste to an existing sheet (the one I initially
created)...

Strange Copy/Paste behavior
 

further testing shows the following:
** insert a new worksheet and then copy/paste fails ...
** open a new workbook, copy/paste from original WB to new one works
fine!

thoughts?