Entering functions in code

  • Thread starter Thread starter H.V.
  • Start date Start date
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Access Dcount function in access 0
CSE with function returning an array? 2
Randomizer Modification Help....... 3
Excel Repeating a RAND() function under certain conditions 0
Error values generated in functions 1
Functions - visibility 3
OFFSET LOOKUP function in VBA? 9

Back
Top