Hello,

Within Excel I am iterating through a loop trying to perform the equivalent of typing 'Alt+1','Alt+2' etc., using SendKeys function. I'm pretty sure it's a timing issue, ie key release and posting http://www.vbforums.com/showthread.php?t=536446, user anhn explains the differences between special character keys and when they are released etc. I have not found a way to get this to work. The code below it simply iterates through spreadsheet and nothing is populated.

I've tried probably 30 permuations with SendKeys function, to no avail.

Many thanks.....Mick

Sub ASCII()
Dim iTmp As Long

Range("A1").Select

For iTmp = 1 To 15
SendKeys "%" & iTmp, True
ActiveCell.Offset(1, 0).Select
Next iTmp
End Sub