VBA to Auto update the formula when changes

[Mohamedazees]

Dear Sir,
I need an excel VBA for auto update the formula In Column D whenever the value changes in cells of Column B ( even if we Paste more than one value in Cells of Coulmn B)

Thanks In advance.

 

[saboh12617]

Hello,
You can add an event handler in the worksheet containing those cells like tho:

Private Sub Worksheet_Change(ByVal Target As Range)
  If Target.Cells(1, 1).Column = 3 Then Columns("D:D").Calculate
End Sub