date row last modified - debug

  • Thread starter Thread starter alex
  • Start date Start date
A

alex

I'm a real nubie with this macro stuff. I googled for a macro and the
below one does exactly what I want but I need help running/debuging
it.

I've read enough Excel 2003 documentation that I need to reference it
from Sub Workbook_Open() .... what I'm missing is how the two
arguments are passed to the sub.

Could I get help debugging and adding to Workbook_Open()

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
'Puts the date & time in column K when the data changes,
'in the rows in columns A-J
'put in worksheet code
If Target.Count > 1 Then Exit Sub
Select Case Target.Column

'columns to check for data change
Case 1 To 10

'where the time is put
Cells(Target.Row, 11) = Now()

End Select
End Sub


(found at: http://groups.google.com/groups?hl=...%24qP86CHA.3332%40TK2MSFTNGP11.phx.gbl&rnum=1
)
 
Hi
just put this code in your worksheet module (not a standard module).
The parameters are passed automatically by Excel.
 
Hi Alex
you put your code in the workBOOK module. It has to go in the correct
workSHEET module!
 
Back
Top