Hi all,

Is there any way that i can do so as not to trigger the Worksheet_Change event of the Excel Worksheet? I would like to write to 2 cells of the worksheet but my program is looping because it keeps on getting into the Change event.

Here's my code.

Private Sub Worksheet_Change(ByVal Target As Range)
If ActiveCell.Column = 3 And (ActiveCell.Row Mod 2) <> 0 Then
ActiveCell.Offset(-1, 1).Value = ActiveCell.Offset(-1, 0).Value + Sheets_
(1).Cells(ActiveCell.Row - 1, ActiveCell.Column)
ActiveCell.Offset(-2, 1).Value = ActiveCell.Offset(-2, 0).Value + Sheets_
(1).Cells(ActiveCell.Row - 2, ActiveCell.Column)
End If
End Sub

thanks a lot!