View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jimbuff jimbuff is offline
external usenet poster
 
Posts: 1
Default Histogram VBA Code won't run in Excel 2003

Hi,

I'm having a strange problem with some VBA code that I
wrote which calls the histogram subroutine that is in the
ATPVBAEN.XLA file. The relevant code is:
Application.Run "ATPVBAEN.XLA!Histogram", inputrange,
outputrange, , False, False, False, False

Excel 2003 (but not earlier versions) craps out with the
error:

Run-time error '1004':
The macro '' cannot be found.

Could anyone suggest any solutions. I've done the obvious
of making sure that the object library is referenced,
macro security is set to low, trust vb applications is
checked.

Thanks in advance.

Jim.