کد زیر رو امتحان کنید مشکل حل میشه
کد PHP:
Option Explicit
Public Function lookupArray(arr As Variant, myrng As Range, mycol As Integer)
Dim code1, code2
Dim intcoun As Integer
Dim arritem As Variant
Dim lookitem As Variant
For intcoun = 1 To (Len(arr) - Len(Application.WorksheetFunction.Substitute(arr, ";", "")) + 1)
arritem = piece(arr, ";", intcoun)
On Error GoTo Errhndler
If InStr(1, arritem, "-", vbTextCompare) <> 0 Then
code1 = Mid(arritem, 1, Application.WorksheetFunction.Find("-", arritem, 1) - 1)
code2 = Right(arritem, Len(arritem) - Len(code1))
Else
code1 = arritem
code2 = ""
End If
arritem = Val(code1)
lookitem = Application.WorksheetFunction.VLookup(arritem, myrng, mycol, 0)
lookitem = lookitem & code2
Errhndler:
If Err.Number = 1004 Then
lookitem = ""
lookupArray = lookupArray & lookitem & ";"
Else
lookupArray = lookupArray & lookitem & ";"
End If
Next intcoun
End Function
Public Function piece(Searchstring As Variant, Separator As String, IndexNum As Integer) As String
Dim t
t = Split(Searchstring, Separator)
If UBound(t) > 0 Then piece = t(IndexNum - 1)
End Function
علاقه مندی ها (Bookmarks)