All along, the macro i recorded to generate a histogram is working fine until today when I tried running it again, it gives a 'Run-time error '1004' the macro " cannot be executed.

What could have been the problem?


Code:
    Application.Run "ATPVBAEN.XLA!Histogram", Worksheets("Calculate").Range("A1:A" & lastrow) _
        , Worksheets("Calculate").Range("$G$1"), , False, False, False, False
any help pls?