Results 1 to 2 of 2

Thread: Error when running histogram in Analysis Toolkit

  1. #1

    Thread Starter
    New Member
    Join Date
    Jan 2006
    Posts
    3

    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?

  2. #2
    Junior Member
    Join Date
    Aug 2006
    Posts
    17

    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
  •  



Click Here to Expand Forum to Full Width