Worksheet Change Event adding formulas to target range not working

[HaroonSid]

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

[xlnitwit]

Hi,

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

[HaroonSid]

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

[xlnitwit]

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

[HaroonSid]

Yes you are right

now please tell me what should i do now?

[xlnitwit]

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.

[HaroonSid]

Ok
thank you very much