View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Zaman Zaman is offline
external usenet poster
 
Posts: 2
Default Problem with ATPVBAEN.XLA

Hi

I'm having problems with the Data Analysis Random Number Generator.
If I record putting random nums in some cells I get this bit of VBA:

Application.Run "ATPVBAEN.XLA!Random", ActiveSheet.Range("$A$1:$A$10"), 1,
10, 2, , 0, 1

When I re-run it it gives a VB error:

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


Repeating the same thing on an older PC it gives the same bit of code and
will re-run.
The strange thing is that it HAS re-run on the first PC before - as part of
a larger simulation program.

Has anyone else experienced this? Or got any ideas as to what may be the
problem?

Thanks