char() function in vba

[lezawang]

Hi
I was hoping to find a function in vba similar to char(). The code below does it work! Any idea on how to do the same thing? Thank you very much.

' print garbage char
Sub garbagechar()
    Dim x As Integer
    For x = 0 To 100
    Cells(x, 1) = WorksheetFunction.char(x)
    Next x
End Sub

 

[Fluff]

just remove the a

 

[offthelip]

there is a Vba function "Chr"
so all you need is
:

[COLOR=#333333]Cells(x, 1) = chr(x)[/COLOR]