|
发表于 2012-11-26 03:00
|
显示全部楼层
本楼为最佳答案
Sub aa()
Dim x, y As String
Dim j!, a!, b!
For a = 16 To 18
For b = 5 To 27
x = "0123456789"
y = Cells(a, b).Value
If y <> "" Then
For j = 1 To Len(y)
x = Replace(x, Mid(y, j, 1), "")
Next j
Cells(a + 6, b) = x
End If
Next
Next
End Sub |
|