|
楼主 |
发表于 2019-12-19 09:19
|
显示全部楼层
老师你好,再麻烦你下
我修改成这样不行呢
'*************************************************************************
If Trim(Cells(Target.Row, "E")) <> "" Then
renArr = Split(Cells(Target.Row, "E"), vbLf)
For i = 0 To UBound(renArr)
If InStr(renArr(i), seltxt(0)) Or InStr(renArr(i), seltxt(1)) Then GoTo 跳转
re = Split(renArr(i), ",")
i = 0
.Tables(2).Cell(5 + i, 2).Range.Text = re(0)
.Tables(2).Cell(5 + i, 3).Range.Text = re(1)
.Tables(2).Cell(5 + i, 4).Range.Text = Format(re(2), "yyyy.mm")
.Tables(2).Cell(5 + i, 5).Range.Text = re(3)
.Tables(2).Cell(5 + i, 6).Range.Text = re(4)
Exit For
''End If
跳转: Next i '当符合上面IF判断的条件时,就跳转至此,退出i
End If
'*************************************************************************
|
|