Worksheet Change Event adding formulas to target range not working

hi,
i am trying to add formula to target cells using worksheets change event but fails every time,

Please Login or Register  to view this content.

thank you

Hi,

I suggest you remove the On Error Resume Next and see what is really happening.

Thank you
its working very well

but i have a problem that this code is very very slow

will you please suggest a better and fast code

thank you

I imagine the majority of the problem is the formulas calculating, not the code.

Yes you are right

now please tell me what should i do now?

I have no idea. You need to try and make your formulas more efficient or reassess your whole approach but it is not possible for me to be more specific.

Ok
thank you very much