很高兴为您解答。我推荐您使用VBA中的split函数来拆分表格的每一行。您可以参考以下代码:
Dim strLine As String Dim arrLine() As String
strLine = "1,2,3,4,5" arrLine = Split(strLine, ",")
For i = 0 To UBound(arrLine) Debug.Print arrLine(i) Next i
很高兴为您解答。我推荐您使用VBA中的split函数来拆分表格的每一行。您可以参考以下代码:
Dim strLine As String Dim arrLine() As String
strLine = "1,2,3,4,5" arrLine = Split(strLine, ",")
For i = 0 To UBound(arrLine) Debug.Print arrLine(i) Next i