Generating alphanumeric id

I've seen this problem before. If you look on your keyboard, usually Top Right, you will see three LED lights. If you see the under under the 'A' icon is lit, you can solve this problem by pressing the "Caps Lock" button on the far left of the keyboard, generally it is under the Tab key

Hope this helps!

Also; you already posted this, and it was solved.

http://www.excelforum.com/excel-prog...unique-id.html

Please don't type in ALL CAPITAL LETTERS. It is considered to be "shouting".

And note that your post does not comply with forum rules.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE] [/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here


Try:

Option Explicit

Sub Test()

Dim id As String
Dim i As Integer
Randomize
For i = 1 To 5
    If Int((2 * Rnd) + 1) = 1 Then
        id = id & Chr(Int(26 * Rnd + 65))
    Else
        id = id & Int(10 * Rnd)
    End If
    Range("A" & i + 1).Formula = id
Next i
'End With
End Sub