With Sheets("WORK")
If .[W6].End(xlDown).Row = .Rows.Count Then MsgBox "無資料": Exit Sub
For Each A In .Range(.[W6], .[W65536].End(xlUp)).SpecialCells(xlCellTypeConstants)
Ar = Split(A, "+")
For Each C In Ar
MyStr = C & "," & Left(A.Offset(, 3), 8) & "," & A.Offset(, 8)
dic1(MyStr) = Split(MyStr, ",")
Next
Next
End With作者: GBKEE 時間: 2015-5-14 08:17