worksheet change code

[rjmdc]

what am i doing wrong if not intersect is failing

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("Additional Expenses")) Is Nothing Then
        
        Call CreateUniqueID(Target)                   'event runs when cell in Column A is changed
        
    End If
    
End Sub

 

[StephenCrump]

Your immediate problem is that "Additional Expenses" (with a space) isn't a valid range name.

 

[rjmdc]

thanks
i fixed it
i really appreciate
i got confused with worksheet name

 

[StephenCrump]

No problem. I'm glad you could fix it.