在你要生成随机数的单元格输入 =RANDBETWEEN(1,10)&" "&RANDBETWEEN(1,10)&" "&RANDBETWEEN(1,10)这样会自动生成3个以空格隔开的随机数。或者输入 =RANDBETWEEN(1,10)&"-"&RANDBETWEEN(1,10)&"-"&RANDBETWEEN(1,10)这样会自动生成3个以“-”隔开的随机数。
如何在Excel中的某一列用vba产生五组1到10的随机数? 能够产生一组随机数会了.五组如果不会用循环,就单独用5次就行了.如下:Public Sub sjs()'以下第一组Dim a As Range, a1 As RangeSet a = Range("a1:a10")a.ClearContentsRandomizeFor Each a1 In aDoa1 = Int(1 + Rnd * 10)Loop Until Applic...