本帖最后由 Akakpk 于 2017-8-18 17:31 编辑
小弟新手,关于IFERROR MID FIND的用法,请大神们修改一下
Dim ar As Integer
Dim acn As String
Dim sht As Worksheet
Dim k As Long
Set sht = ThisWorkbook.Worksheets("sheet1")
k = sht.Cells(sht.Rows.Count, "A").End(xlUp).Row
For ar = 1 To k
range(cells(2,ar)).value =WorksheetFunction.IFERROR(MID(range(cells(1,ar),FIND("AWPX",range(cells(1,ar))+6,2),"0")
next ar
|