Try:

Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo ErrorHandler
Application.EnableEvents = False
If Target.Count = 1 And Target.Row = 12 Then
Cells(11, Target.Column) = Date
End If
ErrorHandler:
Application.EnableEvents = True
End Sub

This is worksheet event code. Right click the sheet tab, select View Code
and paste the code in there.

Hope this helps
Rowan

"oberon.black" wrote:


I would like to have the date show in row'11' if I modify anything in
row '12'. I want to apply this code to the entire row of '11' so that
if I modify 'c12', 'c11' will show the date and so on.


--
oberon.black
------------------------------------------------------------------------
oberon.black's Profile: http://www.excelforum.com/member.php...o&userid=26732
View this thread: http://www.excelforum.com/showthread...hreadid=402018