Target is the cell that changed. To run lony for specific cells or ranges you
need to use an if statement, similar to

If target.address = "$A$1" then
'do your stuff
end if

For a range you need to use the intersect function

if not intersect(target, range("A1:B10")) is nothing then
'Do your stuff
end if



--
HTH...

Jim Thomlinson


"rafik" wrote:



"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