I'm not an export on this, but wouldn't cell C2 be column 3, row 2, not
Column 2?

Sue

"pikus " wrote in message
...
In "ThisWorkbook" Module:

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As
Range)
If Target.Column = 2 And Target.Row = 2 Then
'Do all that other stuff...
End If
End Sub

Is that clear?

- Pikus


---
Message posted from http://www.ExcelForum.com/