This URL has the VBA code for creating a UDF that will determine if a number
is prime or not.

http://www.bluemoosetech.com/microso... me%20Numbers
--
Kevin Backmann


"Eric" wrote:

Does anyone have any suggestions on how to determine the prime numbers?
There is a given number 10 in cell A2, I would like to determine the next
prime numbers below and over this given number 10. In this case, 11 will be
returned in cell A1, and 7 will be returned in A3.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric