Hi Rick -

Add this code to the worksheet's module.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If ActiveCell.Column = 4 Or ActiveCell.Column = 2 Then
MsgBox "Exited Column C..." 'replace this line with a call to your other
macro
End If
End Sub
--
Jay


"Rick" wrote:

How do I triger a macro to run when I exit cell "C1"
Macro is to copy "A1:C1" to another sheet in a different book

This is to be repeated each time I exit column "C_", row after row.


Thanks,
Rick