|
arr = Sheets("数据源").Range("E2:E" & x + 1)
For s = 1 To UBound(arr)
If arr(s, 1) Like "[1]*" Then
arr(s, 1) = "'02"
ElseIf arr(s, 1) Like "[2]*" Then
arr(s, 1) = "'03"
ElseIf arr(s, 1) Like "[3]*" Then
arr(s, 1) = "'01"
ElseIf arr(s, 1) Like "[4]*" Then
arr(s, 1) = "'05"
ElseIf arr(s, 1) Like "[5]*" Then
arr(s, 1) = "'08"
ElseIf arr(s, 1) Like "[6]*" Then
arr(s, 1) = "'09"
End If
Next
.Range("g" & Rown - 1).Resize(UBound(arr)) = arr '数组输出到单元格 |
|