Worksheet_Change event Question

[nicnad]

Hi,

I have a macro that I want to run when a cell is changed in column "D"

I have the following code :

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 4 Then
macro1
End If
End Sub

The thing is that Excel still makes calculation even when I change a cell that is not in the D column. So everytime I change a cell I need to wait 2-3 seconds for Excel to calculate nothing. Is there a way to make this code more efficient?

 

[Smitty]

If you use CTRL+` you can toggle formula view to see all of your formulas.