OK, I think I finally found the problem. My module name is Consecutive_Giving_Analysis. I generally name the module the same name as the subroutine name within that module.
To successfully run the subroutine named Consecutive_Giving_Analysis within the module Consecutive_Giving_Analysis, I needed to do this:

Application.Run "PERSONAL.XLSB!Consecutive_Giving_Analysis.Consecutive_Giving_Analysis"

I had been doing this:

Application.Run "PERSONAL.XLSB!Consecutive_Giving_Analysis"