|
发表于 2012-7-3 10:46
|
显示全部楼层
本楼为最佳答案
本帖最后由 long826121 于 2012-7-3 10:50 编辑
h200797080 发表于 2012-7-3 10:39
If IsNumeric(ar) And ar.Value > 0 Then ar.Font.ColorIndex = 8
& 改成 And 这个数字处理就没有问题 但 ...
Sub 预测分析()
Dim a As Range
Dim i, x As Integer
For x = 1 To Sheets.Count
For i = 2 To Sheets("phase" & x & "分析").Range("A:A").End(xlDown).Row
For Each ar In Sheets("phase" & x & "分析").UsedRange
If IsNumeric(a) > 0 Then a.Interior.ColorIndex = 8
Next
Sheets("phase" & x & "分析").Range("a" & i).End(xlDown).Offset(0, 1) = "=SUM(a" & i & ":a" & Range("a" & i).End(xlDown).Row & ")"
Sheets("phase" & x & "分析").Range("a" & i).End(xlDown).Offset(0, 1).Font.ColorIndex = 13
Sheets("phase" & x & "分析").Range("a" & i).End(xlDown).Offset(0, 1) = "=average(a" & i & ":a" & Range("a" & i).End(xlDown).Row & ")"
Sheets("phase" & x & "分析").Range("a" & i).End(xlDown).Offset(0, 1).Font.ColorIndex = 13
Next
Next
End Sub
已经测试没有问题,我有附件上传不了,网络烂
|
|