ExcelBanter - Need VBA code for Rnadom Number Generator

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Need VBA code for Rnadom Number Generator (https://www.excelbanter.com/excel-programming/359949-need-vba-code-rnadom-number-generator.html)

Shani

Need VBA code for Rnadom Number Generator

I need help creating a random number generator that creates a number
between 60-150. Does anyone know how to do this?

MattShoreson[_97_]

Need VBA code for Rnadom Number Generator

Dim MyValue
MyValue = Int((90 * Rnd) + 60)
Debug.Print MyValu

--
MattShoreso
-----------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...nfo&userid=347
View this thread: http://www.excelforum.com/showthread.php?threadid=53682

All times are GMT +1. The time now is 06:23 AM.