User`s guide

Multiple Files and Variable Arguments Example
To execute the macro, from the main Excel window (not the Visual Basic
Editor), open the Macro dialog box, by pressing the Alt and F8 keys
simultaneously, or by clicking Tools > Macro > Macros.
Select
myprimes from the l ist and click Run.
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 return s all prim e numbers less than
the number you entered in cell A42.
3-11