calling excel function inside vba code

[lezawang]

Hi I am trying to learn how to call excel function inside a vba code but I got an error message doing the following

Sub fillme()
Range("a1:c30") = randbtween(1, 100)
End Sub


any help please. Thank you so much

 

[mikerickson]

You need to use the WorksheetFunction.

Dim oneCell as Range

For Each oneCell in Range("A1:C30")
    oneCell.Value = WorksheetFunction.RandBetween(1, 100)
Next oneCell

Or you could do it in bulk

With Range("B1:C30")
    .Formula = "=RANDBETWEEN(1, 100)"
    .Value = .Value
End With

 

[RoryA]

Use Application.Worksheetfunction.Randbetween and not just Randbetween (and certainly not Randbtween! ).