Sub s1()
Dim x As Integer, ya As Integer
For x = 7 To 26 Step 19
For y = 5 To 16
If x <> 6 Then
Cells(x, y) = Evaluate("=ROUND(CELLS(x-1,y)+CELLS(x+1,Y),1)")
End If
Next y
Next
End Sub
初学,这是根据上次贴的回答引用,结果运算出错误,求解,我的意思就是这样E7=E6+E8 F7=F6+F8依此类推在就是想叫他E7到J7,L7到Q7 E26到J26 L26到Q26这个单元格区域的值都是这样对应单元格相加
本帖最后由 lzclzch 于 2012-8-12 00:54 编辑
Sub s1()
Dim x As Integer, y As Integer
For x = 7 To 26 Step 19
For y = 5 To 17
If x <> 6 Then
Cells(x, y) = Round(Cells(x - 1, y) + Cells(x + 1, y), 1)
End If
Next y
Next
End Sub
|