Function 数字(ByVal rang As String)
Dim i As Integer, str As Integer
For i = 1 To Len(rang) '遍历单元格中每个字符
If VBA.IsNumeric(Mid(rang, i, 1)) Then
str = str & Mid(rang, i, 1)
End If
Next i
数字 = str
End Function作者: oobird 時間: 2010-9-12 21:40
str = str Mid(rang, i, 1)
好像應為
str = str & Mid(rang, i, 1)作者: oobird 時間: 2010-9-13 23:20
