Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return a random letter
You do not need to "assigning all the letters of the alphabet to numbers
between 1 and 26 " Each letter already has a number assigned to it - its ASCII code A-Z are in range 65-90 and a-z in range 97-122 Use you random number function to get a value with in the right range and use the VBA function CHR(n) to return the character. best wishes -- Bernard Liengme www.stfx.ca/people/bliengme remove CAPS in email address "quartz" wrote in message ... I have the following function which works great for returning a random number in a range from a specified low to a specified high: Public Function RandomNumbers(argLow As Long, argHigh As Long) As Long 'RETURN A RANDOM NUMBER BETWEEN 'argLow' AND 'argHigh' Randomize RandomNumbers = CLng((argHigh - argLow) * Rnd + argLow) End Function Now I need a similar function that would return a random letter between A and Z. Can anyone suggest a more efficient method than just assigning all the letters of the alphabet to numbers between 1 and 26 to return a random letter? Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Random Letter Generator | Excel Discussion (Misc queries) | |||
random letter generation | Excel Worksheet Functions | |||
Random letter and number generator | Excel Worksheet Functions | |||
column header changed from letter to number, how return to letter | Excel Discussion (Misc queries) | |||
Return a random letter | Excel Programming |