User`s guide

Creating Reports Easily Using ActiveX Chapter 6
VEE User’s Guide 261
10 Create a Formula object and an AlphaNumeric object, rename,
configure, and connect them as shown in
Figure 153.
sheet.cells(A+1,1)
= random(1,100)
This statement is shorthand for
sheet.cells(A+1,1).value=random(1,100).
The worksheet cell at row A+1, col 1 gets the row number
by adding 1 to the input pin A value but stays in column 1.
The value between
1 and 100 returned by random is
assigned to the specified cell in the worksheet.
from 1 thru 20,
step 1 (the
For Range object)
As the For Range object outputs the integers from 1 to 20,
Fill in Cells puts the random number in the specified cell.
Table 2 6 Instructions in Formula Objects and the For Range Object
Formula Description