VBA novice problems when using the free function for the first time

liyang

Put a button on Excel's sheet1, and the event is as follows.

Private Sub CommandButton1_Click ()
Worksheets ("Sheet1"). Cells (2, 2) .Value = rand ()
End Sub

After running, I get the following error: "Compile error: Subroutine or function is not defined"

What's going on?

w9900403

rand () should be rnd ()