User`s guide

3 Usage Examples
• The second (cell A19) takes a range objectthatisarangeofcellswiththe
values 1 through 10, adds them, and returns the result of 55.
• The third (cell A24) takes several range objects, adds them, and returns the
result of 120. This illustration demonstrates that the ranges do not need to
be the same size and that all the cells do not need a value.
• The f ourth (cell A30) takes a combination of a range object and explicitly
stated values, adds them, and returns the result of 16.
This illustration ru n s when the E xcel file is opened. To re activate the
illustration, activate the appropriate cell. Then press F2 followed by Enter.
Illustration 6: myprimes Macro
In this illustration, the macro myprimes calls the function myprimes.m with
an initial value of 10 in cell A42. The function returns all the prime numbers
less than 10 to cells B42 through E42.
3-10