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?
Error when running histogram in Analysis Toolkit
