Worksheet_SelectionChange is blocking copy pastespecial function ..please help

**wellous** · 10-13-2014, 09:50 AM

Hello Experts,

i am having an issue with worksheet_selectionChange function as it's blocking pastespecial function usned by another marco!!
i am attaching a sample for ref.

i have worksheet(2) which has some records to be copied from another sheet ... this is working probably good without the selection function...
when i wanted to add another function [Worksheet_SelectionChange ] to calculate the counts of some records in sheet(2) module according to selected rows - the result is good for th second function ...but when i want to run the first macro to do copy/pastespecial it gives me error!!!

what is wrong with the code,

many thanks for your help,
Wellous

**TMS** · 10-13-2014, 10:01 AM

You need

Please Login or Register  to view this content.

before the PasteSpecial. Set it to True afterwards.

Regards, TMS

**wellous** · 10-13-2014, 12:51 PM

Thanks TMS,
is it that simple

thanks again

**TMS** · 10-13-2014, 01:01 PM

is it that simple

yep.

You're welcome. Thanks for the rep.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.