I must be missing something here because this did nothing.

"Dave Peterson" wrote:

Right click on the worksheet tab that should have this behavior and select view
code. Then paste this into the newly opened codewindow.



Picman wrote:

Could you walk me through the "worksheet code area". I'm not familier with
this part of Excel. Also how can i change the coordinates of the destination
cell to allow for column headings etc?

"Gary''s Student" wrote:

Put the following macro in the worksheet code area:

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
Cells(Target.Row, 1).Value = "C"
Application.EnableEvents = True
End Sub

--
Gary''s Student - gsnu200738


"Picman" wrote:

I would like to indicate with a specific value ("C") in the first cell of a
row if any changes have been made in that row since the file was created. In
other words if a value was input or changed in cell "M1" i would like cell
"A1" to be populated with a "C". Can this be done?

--

Dave Peterson