Not Pasting values in Excel file

Solved/Closed
Report
Posts
77
Registration date
Saturday September 5, 2015
Status
Member
Last seen
March 8, 2017
-
Posts
77
Registration date
Saturday September 5, 2015
Status
Member
Last seen
March 8, 2017
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Posts
77
Registration date
Saturday September 5, 2015
Status
Member
Last seen
March 8, 2017
1
Hi
rizvisa1

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