Adding up in Excel.

Private Sub Worksheet_Change(ByVal Target As Range)

NOT

Sub Worksheet_Change()

you put it in the woeksheet module not a new module ,you dont run it it is automatic