With Tables("表A")
Dim cns() As String = {"序号","英文","音标","汉语"}
For Each r As Row In .Rows
If r("录入").Contains("Lesson") = False Or r.IsNull("录入") = False Then
If r("录入").Contains("[") Then
Dim strs() As String = r("录入").Split(" ")
For i As Integer = 0 To cns.Length - 1
r(cns(i)) = strs(i)
Next
End If
End If
Next
End With
此主题相关图片如下:qq截图20161223222043.png

[此贴子已经被作者于2016/12/23 22:22:59编辑过]