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
767
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 2942 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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!