M merjet Nov 14, 2003 #2 How can you use the random function within your code? If you mean the worksheet function RAND, it is not available in VBA. However, Rnd() is its equivalent. X = Rnd() would assign to X a number >=0 and <1. HTH, Merjet
How can you use the random function within your code? If you mean the worksheet function RAND, it is not available in VBA. However, Rnd() is its equivalent. X = Rnd() would assign to X a number >=0 and <1. HTH, Merjet