Trouble with If Then Else statement

Another question... if you take a look at the code from the original post, I think I have something else wrong. I'm not too familiar with VBA, so I'm sort of fumbling along...

I'm trying to write the macro so that it only fires when certain cells are changed. Those cells are within a range that I've named IncurredTC100. Could someone tell me how I can achieve this?

Thanks!

Hello JChandler22,

Here is how. Add this line where appropriate in your Worksheet_Change code...

If Intersect(Target, IncurredTC100) Is Nothing Then
  ' Exit the macro if selected cell is not part of the range
   Exit Sub
End If

Sincerely,
Leith Ross