By using vba.booksticle.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

948 Steps to 6 Figures by Learning Excel-VBA and Other Skills

Step 854 - Get a Random number between 1 and a Million

[=randbetween(1,1000000)] - returns a random number between 1 and 1,000,000

Immediate Window





? [=randbetween(1,1000000)]

77236



a = [=randbetween(1,1000000)]

? a

87276



? [=randbetween(1,1000000)] + [=randbetween(1,1000000)]

1822800