How to trigger a macro from range not on active sheet

Hi,

Is it possible to trigger a macro from a change in a range of formula cells if that range is NOT on the active sheet?

Basically, I have a dynamic range of dates on a calculation sheet where the dates can change or dates can be added/deleted, and every time there is any change in that range I need to fire a macro. I found some code that will trigger based on a formula result, but the range had to be on the active sheet. Is there code that can do this?

Thanks,

Lawrence

That works beautifully!

And it's so simple. Many of the macros I found included additional code. Do you know what the bold lines below mean?

Private Sub Worksheet_Change(ByVal Target As Range)
    
    On Error GoTo ErrH

    'Check target to determine if macro is triggered
    If Not Intersect(Target, Range("Database01_Dates")) Is Nothing Then

    Application.EnableEvents = False
        'Do things as a result of a change
        Database01_EOMONTHFill
        Database01_ClearAfterLastRow

    End If

ErrH:
    Application.EnableEvents = True

End Sub

Thanks for your help!

Lawrence

Originally Posted by Richard Buttrey

Hi just use the sheet change event on the sheet in question and use the following

IF Not Intersect (Target, your_range) Is Nothing Then
'your macro

End If

HTH

Ooops...Hold it. I can't get the macro to fire when the sheet where the range is located isn't the active sheet and that formula results change. Is my code above missing something?

Lawrence

Okay, I've narrowed this down. The above code only works (the macro only fires) when a cell in the range is manually keyed. What I need is to also have the macro fire when the formal result changes.

Is that a calculation event os some kind???

Lawrence