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]

You can use:

Application.Calculation = xlManual

and set it back to Automatic at the end:

Application.Calculation = xlAutomatic

HTH,

 

[nicnad]

For some reason Excel still does calculation when I change any cell in the worksheet. Do you have any other advices?

 

[GTO]

Not utterly sure, but would suspect too many volatile functions.

 

[nicnad]

The only functions I have on this sheet are hyperlink. But I have many other sheets that refer to value in this sheet. Could this be the problem and how do I solve it?

 

[Smitty]

Try setting calculation to Manual through File-->Options and see what happens.

 

[nicnad]

I don't want to deactivate the automatic calculation. Is there any other way around?

 

[Smitty]

If you want to stop calculation I can't think of any other way than turning it off.

 

[GTO]

Just curious - have you looked to see what formulas or CF or ? is being calculated ea time?

 

[nicnad]

How can I look at what is being calculated?