User`s guide

4 Usage Examples
4-16
Figure 4-14: myprimes Output for Value of 10
This function automatically resizes if the returned output is larger than the
output range specified. Change the value in cell A42 to a number larger than
10. Then rerun the macro. The output returns all prime numbers less than the
number you entered in cell A42.
Figure 4-15: myprimes Output for Value > 10
Inspecting the Visual Basic Code
From Excel select Visual Basic Editor from the Tools -> Macro menu.
From the Visual Basic Editor, in the
Project - VBAProject window, expand the
project
VBAProject (mymulti.xls).
Expand the
Modules folder and double click on the Module1 module. This opens
the
VB Code window with the code for this project.