|
Sub 从指定区域内随机取一个单元格()
Sheet3.Cells(35, 2).Value = Application.WorksheetFunction.Index([a32:e33], RANDBETWEEN(1,2),RANDBETWEEN(1,5))
End Sub
结果运行后告诉我子程序或函数未定义,是哪里出问题了呢?
Sub 从指定区域内随机取一个单元格()
Sheet3.Cells(35, 2).Value = Application.Index([a32:e33], Application.RandBetween(1, 2), Application.RandBetween(1, 5))
End Sub
|
|