Not Pasting values in Excel file

Solved/Closed
smuneeb Posts 77 Registration date Saturday September 5, 2015 Status Member Last seen March 8, 2017 - Dec 3, 2015 at 04:07 AM
smuneeb Posts 77 Registration date Saturday September 5, 2015 Status Member Last seen March 8, 2017 - Dec 5, 2015 at 12:36 AM
Hello,


I would like to know that I have a Excel Macro Enabled File.

it has macros, sheet vba code, modules and user forms code and no merging cells

but problem is that whenever or whatever I'm trying to paste any values, it's not pasting the values

just shows once action that pasted and in a second it automatically removes the values not only from the file but also from the memory.

Please help me to solve this unique problem

Thanks

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Dec 3, 2015 at 11:40 AM
There must be some event that is cleaning it out.
Simple test would be
Before pasting, execute code
Application.EnableEvents = False
that disables the event
1
smuneeb Posts 77 Registration date Saturday September 5, 2015 Status Member Last seen March 8, 2017 1
Dec 5, 2015 at 12:36 AM
Hi
rizvisa1

You have solved my problem
but i don't like it
I L O V E it
Thanks
0