Not Pasting values in Excel file [Solved/Closed]

Question

Previous Topic Next Topic

Not Pasting values in Excel file [Solved/Closed]

Report

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

Not Pasting values in Excel file
Excel vba copy paste values next empty column - Forum - Excel
Excel - Copy and paste values from specific columns - How-To - Excel
Excel vba copy and paste values to another workbook - How-To - Excel
Excel vba copy paste values next empty row ✓ - Forum - Excel
VBA Copy and paste range to next empty cell(s) to right - Forum - Excel

1 reply

Ask a question

rizvisa1 · Accepted Answer · 2015-12-03T11:40:36-0500

Answer 1 / 1

rizvisa1

Posts: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

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

Report

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

Not Pasting values in Excel file [Solved/Closed]

1 reply

Your reply

Subscribe To Our Newsletter!