excel中，B1为最大值，B2为最小值，使用vba生成9个小数点后保留两位的随机数，要求在最大值与最小值之间，且9个数波动范围不能超过0.04并填到C4-C12中

在Excel VBA中，你可以使用`Rnd`函数生成随机数，并结合条件判断来满足你的需求。下面是一个简单的VBA代码示例：

Sub GenerateRandomNumbers()
    Dim max As Double, min As Double, diff As Double
    Dim randNum() As Double
    Dim i As Integer
    
    ' 获取B1和B2的值
    max = Range("B1").Value
    min = Range("B2").Value
    diff = max - min
    
    ' 检查波动范围是否大于0.04
    If diff < 0.04 Then
        MsgBox "波动范围小于0.04，无法生成9个随机数", vbInformation, "警告"
        Exit Sub
    End If
    
    diff = diff - (diff * 0.04) ' 确保总波动不超过0.04
    ReDim randNum(1 To 9) ' 初始化数组大小
    
    For i = 1 To 9
        ' 生成一个在[min, min+diff]之间的随机数，并四舍五入到小数点后两位
        randomNum = Round((min + Rnd() * diff), 2)
        Range("C" & (i + 3)).Value = randomNum ' 填充到C列
    Next i
End Sub

运行此宏后，它将在C4到C12单元格中生成9个在B1和B2值之间波动不超过0.04的小数，并保留两位小数。