"Richard Mertl" wrote:

The macro below will run each time a value is changed by the user in any
sheet.Let me know if this what you want.Private Sub
Workbook_SheetChange(ByVal Sh As Object, ByVal Source As Range)
' runs when a sheet is changed
End Sub"rafik" wrote in message
...
can you please show me how to run a macro after a change a cell
thank you in advance

thank you it worked but the macro runs for all the cells
can we make it specific to one cell or a range
thank you in advance