what am i doing wrong if not intersect is failing
Rich (BB code):
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