Excel 2007 Macro after copy the fil

[khalil]

hi all
please help me in this issue

i have macro in excel sheet, it works for few times , after copying the file or modifying the file ten it doesn't work , i have to cut code then paste it again .


thanks

 

[jim may]

Always POST your existing code.

 

[khalil]

hello,
here is the code,


thanks for the tip


Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("x:x")) Is Nothing Then
Application.EnableEvents = False
Target.Offset(0, -23).Value = Date
Application.EnableEvents = True
End If
If Target.Address(False, False) = "AW7" Then
If Target.Value = "" Then
Application.EnableEvents = False
Target.Value = "?"
Application.EnableEvents = True
End If

End If
End Sub

 

[jim may]

I don't see the problem.
sorry,
Jim

 

[khalil]

thanks for the feed back

but what happens when i add extra rows including other array formulas

i lose the function of this code, the code stays but doesn't function,

thanks