Microsoft KB Archive/94215

{|
 * width="100%"|

Excel: RANDOM Needs Values for Variables, Points, and Seed

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, versions 4.0, 4.0a, 5.0

-

SYMPTOMS
&quot;Online Help&quot; for version 5.0 and page 345 of the version 4.0 &quot;Microsoft Excel Function Reference,&quot; state that the syntax for the RANDOM function specifies that the variables, points and seed parameters are optional. If any of these parameters are omitted, the function returns an error message.

STATUS
Microsoft has confirmed this to be a problem in the versions of Microsoft Excel listed above. We are researching this problem, and will post more information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION
When you use the RANDOM function, the variables argument specifies the number of columns in the output range, the points argument specifies the number of rows in the output range, and the seed argument specifies an offset value used in determining which random numbers to retrieve. In Microsoft Excel for Windows, you must specify a value for each of these variables or you will receive the following error message when the RANDOM function is evaluated in your macro:

An error has occurred locating a support file or processing data for an add-in procedure

WORKAROUND
To work around this problem, specify these three parameters, as follows

  variables argument= COLUMNS(range) points argument= ROWS(range) seed argument= INT(RAND*range) or any positive integer value

where range is the reference to the area on the worksheet where you want to place the random numbers.