Sub test()
Dim j, a As Integer
a = Evaluate("=counta(i:i)")
For j = 3 To a
Range("i" & j) = Evaluate("=MID(i " & j & ",3,3)") & ""/"" & MID(i " & j & ",7,2) & ""/"" & MID(i " & j & ",10,2)")
Next
End Sub
還是報錯
Sub test()
Dim j, a As Integer
a = Evaluate("=counta(i:i)")
For j = 3 To a
Range("i" & j) = Evaluate("=MID(i " & j & ",3,3)") & ""/"" & MID(i " & j & ",7,2) & ""/"" & MID(i " & j & ",10,2)")
Next
End Sub
還是報錯