I want to run a macro (just makes sure the end user doesn't accidentally
delete some of the formulas from a column) when the user adds/changes any
cell value. The idea is that they input the following on each line, and the
Total column multiplies the unit cost by the quantity.

Product Unit Cost £ Quantity Total


However, if they add rows the formula disappears and the calculation doesn't
work. I want to add a macro so when they add/change any of the left hand
cells (even if they have added a row) the formula will appear in the totals
column and complete the calculation.

Any ideas?