|
-
Feb 23rd, 2006, 01:19 PM
#1
Thread Starter
New Member
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?
-
Dec 18th, 2009, 04:18 PM
#2
Junior Member
Re: Error when running histogram in Analysis Toolkit
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|