Worksheet_change_event When i delete any entry form target row then macro stop work

[HaroonSid]

hi
i am using below code to add some data and formulas copy paste as i type in column c

but sometimes i type wrong and i delete the entry then code stops to work,
no i close the workbook and open it again to work my worksheet change event

thanx alot

Please Login or Register  to view this content.

[Richard Buttrey]

Where does the code stop working?

[HaroonSid]

than a lot for reply

it it not showing an error, just stoped working
if delete an entry from target row (range c) then it not copy the data
if i delete multiple entries then its working ok

[bulina2k]

At the first sight from what I can notice you stop the events from triggering and if target = "" (like delete content does) you never put event on:

Please Login or Register  to view this content.

your code stops working because Application.EnableEvents remains False

[HaroonSid]

HI, bulina2k

thanx for reply

yes u r right

now tell what i do? or correct my code plz

[HaroonSid]

or
help me to combine above code correctly

thanx

[bulina2k]

you should take the Application.EnableEvents = True out of the next if else :

Please Login or Register  to view this content.

[HaroonSid]

Thanx a lot
bulina2k

yes you r rignt, i correct the code as u mentioned above,

plz check on again in all event if any mistake found plz correct this one too

[HaroonSid]

Thanx a lot
bulina2k

yes you r rignt, i correct the code as u mentioned above,

plz check on again in all event if any mistake found plz correct this one too

[HaroonSid]

yes,
its working perfectly

thanx a ton to you mr. bulina2k