Copy paste not working after save of worksheet
 

Hi,

1. Open Excel 2003
2. Copy/Paste 1 cell
3. Save
4. Paste again - Not working because save cleared it.

What can be done that after a save the cell content still can be
pasted? Is there an Excel setting and can this be done programmatically
using VBA?

Thanks for your help!

Reto
www.collaboral.com

Copy paste not working after save of worksheet
 

Just to clarify, step 3 means a File Save.

Copy paste not working after save of worksheet
 

Hi R,

Saving the file clears the clipboard. I believe that this behaviour is true
for all versions of Excel and may not be changed.

You could store the required properties in one or more variables.


---
Regards,
Norman


wrote in message
oups.com...
Hi,

1. Open Excel 2003
2. Copy/Paste 1 cell
3. Save
4. Paste again - Not working because save cleared it.

What can be done that after a save the cell content still can be
pasted? Is there an Excel setting and can this be done programmatically
using VBA?

Thanks for your help!

Reto
www.collaboral.com