Strange Copy/Paste behavior

R

Ray

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
 
R

Ray

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

Ray

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Explain THIS ... 9
Macro to copy value in field and insert it into filter 2
Copy & paste macro for multiple worksheets 8
Macro to copy/paste from one workbook to another 8
Macro to Copy / paste from 1 workbook to another 6
copy and paste data (includes groups...) 1
Copy & paste to protected sheet 3
Copy/Paste 3

Top