Auto Trigger Macro to Sort using VBA

[Holbie]

So I used this method posted about 6 months ago to create a triggered macro to sort a table that updates based on queried data and new calculations.

It was working fine this morning, I came back from lunch and it is now broken.

I changed nothing at all but it will not sort now when the data changes in the table. Can anyone help with this please. below is my macro trigger, The macros themself will run and perform the desired sort when triggered manually, but do not auto sort the table when the ranking changes now.

Private Sub Worksheet_Change(ByVal Target As Range)


    If Not Intersect(Target, Range("Site_DB")) Is Nothing Then
        Macro3
    End If
    
    If Not Intersect(Target, Range("Team_DB")) Is Nothing Then
        Macro1
    End If
    
End Sub

There are two tables with dynamic data tied to a larger data table the queries a cube on our server and a few other reports that overwrite to a static location. Why will this no longer trigger the appropriate macros to run when the data in the tables chagne?

 

[Logit]

Make certain "Site_DB" and "Team_DB" still exist ...

 

[Holbie]

Make certain "Site_DB" and "Team_DB" still exist ...

yep still defined tables. they are full of lookup and calculate formulas with the ranking column being my desired column to keep in order.

 

[Logit]

Has your computer been shut down and restarted since you returned from lunch ? Maybe it just needs a boot in the ...

 

[Holbie]

Has your computer been shut down and restarted since you returned from lunch ? Maybe it just needs a boot in the ...

Just restarted and haven't had any data Update as of yet, to try again.

does the VBA look correct to be triggered by a change in the table?

 

[Logit]

It does at first glance. But I haven't tested it here.
If it worked before and you haven't changed anything then ....