Copy data from one Worksheet to other Worksheet not working

It is for Excel programming like Macro, function, formula, Pivot and other platform support..
alpeshviranik
Posts: 81
Joined: Thu Jul 17, 2014 4:58 pm
Contact:

Copy data from one Worksheet to other Worksheet not working

Postby alpeshviranik » Sun Jul 27, 2014 9:54 pm

not able to copy data from one worksheet and paste into another worksheet within the same workbook. I have seen in some workbook it is working.


Guest

Re: Copy data from one Worksheet to other Worksheet not work

Postby Guest » Mon Jul 28, 2014 5:28 pm

Let's say you want to copy data from worksheet2 to worksheet1.
you can write enableevents= false in worksheet_activate sub routine of worksheet2.
e.g. Application.EnableEvents = False

now when you go in worksheet1 it will shut down all other custom function which is preventing to copy from worksheet2 to worksheet1.
Let me know if it will not work for you. It worked for me and i am sure it will work.


Return to “Microsoft Excel and VBA Forum”

Who is online

Users browsing this forum: No registered users and 1 guest