|
发表于 2012-11-30 10:39
|
显示全部楼层
本楼为最佳答案
Sub cha()
Dim a, b, c, rng, rn
On Error Resume Next
For a = 9 To 470
b = 0
c = 5115
Set rng = Range("o" & a, "gns" & a).Find("*", , , , , xlPrevious)
Set rn = Range("o" & a, "gns" & a).Find("", , , , , xlPrevious)
b = rng.Column
c = rn.Column
If b - c <> 0 Then
Range("gns" & a + 466) = b - c
Else
Range("gns" & a + 466) = 0
End If
Next
End Sub- =MATCH("々",A9:GNS9)-MAX(IF(O9:GNS9="",COLUMN(O:GNS),))
复制代码 VBA我水平太差 代码太慢。。。还是优化下公式来的快{:301:}
|
评分
-
查看全部评分
|