filling cells with random char

[lezawang]

Hi
I wrote the code below to fill cells with random char. It does not work. I also have another question. Why Char() is not part of Application.Worksheetfunction?
I thought all excel functions that you can find in Fx, you can find then under Worksheetfunction. But that is not the case. I found Application.Chr function and I tried to use it in my code blow. Thank you so much.

Sub selection_fill2()
    'fill selection with random number
    Dim xcell As Range
    Dim x As Integer
    For Each xcell In Selection
        x = Application.WorksheetFunction.RandBetween(1, 56)
        xcell.Value = x
        xcell.vaule = Application.Chr(x)
    Next xcell
End Sub

 

[tyija1995]

Hey,

you want something like this?

Sub selection_fill2()
    'fill selection with random number
    Dim xcell As Range
    Dim x As Integer
    For Each xcell In Selection
        x = Application.WorksheetFunction.RandBetween(1, 56)
        xcell.Value = Chr(x)
    Next xcell
End Sub

Char is Chr in VBA and is not so much an application but a transformation

 

[lezawang]

Thank you for your help. I appreciate it. I am a bit confused now. When I need to call a VBA function with Application.FunctionName
and when I need to call them with just FunctionName?

According to this link https://www.techonthenet.com/excel/formulas/index_vba.php these functions can be called using Application.FunctionName
or that is what I thought?

Thank you.

 

[tyija1995]

I don't think there is that much difference really, maybe some slight differences with error handling(?) as far as I am aware both are fine to use? Interesting question though