automatically-execute-an-excel-macro-on-a-cell-change

[ricklou]

I have data in column B2-B77 ...I have this macro but I dont know how to make it work with my code....If any value in this range B2-B77 change it must automatically run a macro I have named "History". Rep given for a fundi for the code to make it work -here is the code. My workbooks name is Monday and the sheets name is Seq


Thank you

Dim cell_to_test As Range, cells_changed As Range

    Set cells_changed = Target(1, 1)
    Set cell_to_test = Range( RANGE_OF_CELLS_TO_DETECT )

    If Not Intersect(cells_changed, cell_to_test) Is Nothing Then 
       Macro
    End If