Thread
:
Macro not running when a change occurs
View Single Post
#
3
Posted to microsoft.public.excel.programming
Gord Dibben
external usenet poster
Posts: 22,906
Macro not running when a change occurs
Worksheet_Change event is not triggered by a calculated value change.
Use Worksheet_Calculate event
Gord Dibben MS Excel MVP
On Thu, 16 Oct 2008 09:52:01 -0700, Macro not running as intended <Macro not
running as
wrote:
I am having trouble getting a macro to "fire" when a cell change is made.
The cell is a formula, and the formula is based on a cell that "refreshes"
every 30 minutes from a web query. When the cell hits a certain value it
should send an email to several workers, but this does not occur.
Any thoughts/suggestions?
here is the code:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim rng As Range
If Target.Cells.Count 1 Then Exit Sub
On Error GoTo EndMacro
If Not Target.HasFormula Then
Set rng = Target.Dependents
If Not Intersect(Range("C11"), rng) Is Nothing Then
If Range("C11").Value < 0 Then MYMACRO
End If
End If
EndMacro:
End Sub
Reply With Quote
Gord Dibben
View Public Profile
Find all posts by Gord Dibben