On May 21, 7:16*pm, "Norman Jones"
wrote:
Hi Shahzad,

=============
I am already using the following event in the worksheet.

Private Sub Worksheet_Change(ByVal Target As Range)

again same event giving the errors.

now what to do.
=============

Amalgamate the two Worksheet_Change
procedures into a single procedure, perhaps
adding the body of the other procedure
before the

* * * * End Sub

line of my suggested procedure.

If you experience problems with such
amalgamation, *post the code of the other
procedure in a response in this thread,

---
Regards.
Norman


Good Morning Mr. Norman.

I tried your suggession, it is working vecy nice. E cell is protected
and no chance for deletion by mistake. very good.

Auto calculation is working perfect. I am very happy now.

Thank you very much.

Regards.

Shahzad