Worksheet_Change- only if specific range is changed

[jmthompson]

Hey guys,
I have a bit of code that is working, but very slowly. I believe this is because my Worksheet_Change code is calling another macro that is changing the worksheet.

How can I change this so that my worksheet code is only activated when a (semi)specific range is changed? Semi because the number of rows is variable.

Here is the code in my worksheet

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("A:G")) Is Nothing Then Exit Sub
If Range("A2") = "" Then Exit Sub
Call Complete_Data
End Sub

I would like to change it to activate only when a cell in columns A:G is changed.

 

[jmthompson]

Never mind, it wasn't the Worksheet_Change code that was the problem, it was how I sequenced Complete_Data