ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Entering functions in code (https://www.excelbanter.com/excel-programming/282595-entering-functions-code.html)

H.V.

Entering functions in code
 
How can you use the random function within your code?

H.V.

merjet

Entering functions in code
 
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




All times are GMT +1. The time now is 08:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com