User`s guide

262 VEE User’s Guide

6 Creating Reports Easily Using ActiveX Chapter

Figure 153 The Results Average Program

The entries in the Formula object are as follows:

Table 2 7 Formula Object Entries

Entry Description

set range =

sheet.range(“A2:A21");

Sets the VEE variable range to reference the range

to A21 on the Excel worksheet. (A refers to the

first column in a worksheet.)

range.NumberFormat =

“##,#00.00";

Assigns the format to each of those cells with the

pound signs (

#) allowing for larger numbers, if

necessary.