Error when running histogram in Analysis Toolkit

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?

First, check the references to make sure the atpvbaen.xls reference is available. Then, try something like:

HTML Code:

---

Application.Run "Histogram", ActiveSheet.Range(INPUT VALUES), _
ActiveSheet.Range(OUTPUT VALUES), ActiveSheet.Range(BIN RANGE), False, False, False, False

---

Good luck