7,763
社区成员
发帖
与我相关
我的任务
分享
On Error Resume Next
For j = 2 To a - 2
tmp = 3
For i = 4 To b - 2
If Val(MSHFlexGrid1.TextMatrix(a - 1, i)) > Val(MSHFlexGrid1.TextMatrix(a - 1, tmp)) Then tmp = i
Next i
if Val(MSHFlexGrid1.TextMatrix(j, tmp))=0 then
MSHFlexGrid1.TextMatrix(j, b - 1)=""
else
MSHFlexGrid1.TextMatrix(j, b - 1) = Val(MSHFlexGrid1.TextMatrix(j, 2)) / Val(MSHFlexGrid1.TextMatrix(j, tmp))
end if
Next j