First, Subject line is for a subject, put your question in the main text body.



Put the macro in the worksheet Module and use


Private Sub Worksheet_Change(ByVal target As Excel.Range)
if target.address = "Celladdress you want to change" then

'code to run here

end if
end sub
--
When you lose your mind, you free your life.


"Demian" wrote:

Thanks in advance
Tomasz