Worksheet Change Event Is very Slow To work copy formula and paste

hi,
i am using below code to copy and paste data using Worksheet Change Event
Please Sort Out why this code is very slow to work in my pc
thank you

Please Login or Register  to view this content.

Does this help?

Please Login or Register  to view this content.

You have been modifying code for a long time. I am sure you are already familiar with this trick. Why do you not try it yourself?

Please Login or Register  to view this content.

You are copying and pasting these ranges:
A11:E11
I11:Y11
AB11:AI1

If only values (not formats) required then those values can be attributed instead of being copied with:

Please Login or Register  to view this content.

Originally Posted by kev_

You are copying and pasting these ranges:
A11:E11
I11:Y11
AB11:AI1

If only values (not formats) required then those values can be attributed instead of being copied with:

Please Login or Register  to view this content.

HI, KEV

Thank you for the reply

I am copying formulas so i think this trick will not help

Thank you kev

Please Login or Register  to view this content.

now code is working better then previous

i have one question
i want if (Target, Range("F11:F1000").Value = Greater Then 0 Then Apply this code otherwise exit

Please Login or Register  to view this content.

replace:

Please Login or Register  to view this content.

with:

Please Login or Register  to view this content.

sorry for the wrong info
that was not range f10:f1000, that is range e10:e1000
i want if (target,range("e10:e1000")).value > then exit sub

i want if (target,range("e10:e1000")).value > then exit sub

So are you saying: when I change cell F20, check cell E20 - if E20 is greater than 0 then exit sub ?

If you are, then
replace:

Please Login or Register  to view this content.

with:

Please Login or Register  to view this content.

Perfect

thank you kev