|
新人求助
代码如下:
Public Sub test()
For x = 1 To Range("A65536").End(xlUp).Row
t = 1
If Cells(x, 5) = "z" Then '
Cells(x, 5).Interior.ColorIndex = 6 '
Cells(x, 5) = Application.WorksheetFunction.Average(Range(Cells(t + 4, 5).Address & ":" & Cells(x - 1, 5).Address))
t = x
End If
Next x
End Sub
想用查找的方式找到第5列的“z”,然后在这个单元格利用average函数求得上一段数据的平均平均值。。。然后报错:不能取得worksheetfunction的average属性
好吧,看了一下你的数据,大概知道你指的问题是什么了,代码:
- Public Sub test()
- t = 1
- For x = 1 To Range("A65536").End(xlUp).Row
- If Cells(x, 5) = "z" Then
- Cells(x, 5).Interior.ColorIndex = 6
- Cells(x, 5) = Application.WorksheetFunction.Average(Range(Cells(t + 4, 5).Address & ":" & Cells(x - 1, 5).Address))
- t = x
- End If
- Next x
- End Sub
复制代码
|
|