Maybe better use the Workbook_SheetChange-event which hangs above the
Worksheet_Change-events.

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
If Target.Column = 11 Then 'Column K
MsgBox Sh.Name
End If
End Sub




"RaY" schreef in bericht
...
Hi guys,
Can anyone help me with this?
In my Excel, the whole column K is for entering number, initially it
has
no value. I will keep updating and entering values into column K everyday.
The problem is: I want to run a macro when I have done some changes with
column K. I am not sure how many data I will put in but no more than 300 I
think.
Am I using Worksheet_Change function and I am not sure where should I
put
this function. Since I have 12 worksheets like that (12 months), where
should
I put the code?
Thanks for helping.

Ray