Sub addgrp展開1()
Dim Map As Scripting.Dictionary
Set Map = New Scripting.Dictionary
' Dim info(100, 100) As String
Dim name As String
Dim outarr(100, 2) As String
出力i = 0
'3列目はサーバ名称
pol_fullstr = Cells(3, 2).Value
pol_arr = Split(pol_fullstr, vbLf)
num_pol_arr = UBound(pol_arr, 1)
For pol_i = 0 To num_pol_arr
'GRP有無検索
For grp_i = 22 To 23
If pol_arr(pol_i) = Cells(grp_i, 2).Value Then
outarr(出力i, 0) = pol_arr(pol_i)
f_higrp = 1
member_fullstr = Cells(grp_i, 3).Value
member_arr = Split(member_fullstr, vbLf)
num_member_arr = UBound(member_arr, 1)
'MsgBox num_member_arr
For member_i = 0 To num_member_arr
outarr(出力i, 0) = pol_arr(pol_i)
outarr(出力i, 1) = member_arr(member_i)
' MsgBox member_arr(member_i)
' Range(Cells(12, 2), Cells(18, 3)).Select
outarr(出力i, 2) = Application.WorksheetFunction.VLookup(member_arr(member_i), Range(Cells(12, 2), Cells(18, 3)), 2, False)
' MsgBox outarr(出力i, 2)
出力i = 出力i + 1
Next member_i
End If
Next grp_i
If f_higrp = 0 Then
'add検索
addrip = WorksheetFunction.VLookup(pol_arr(pol_i), Range(Cells(12, 2), Cells(18, 3)), 2, False)
outarr(出力i, 0) = pol_arr(pol_i)
outarr(出力i, 1) = pol_arr(pol_i)
outarr(出力i, 2) = addrip
MsgBox outarr(出力i, 1)
出力i = 出力i + 1
End If
f_higrp = 0
Next pol_i
outarr_conc_1 = ""
For k = 0 To UBound(outarr, 1)
outarr_conc_1 = outarr_conc_1 & vbCrLf & outarr(k, 0)
outarr_conc_2 = outarr_conc_2 & vbCrLf & outarr(k, 1)
outarr_conc_3 = outarr_conc_3 & vbCrLf & outarr(k, 2)
MsgBox UBound(outarr, 1)
' Cells(k + 50, 1).Value = outarr(k, 0)
' Cells(k + 50, 2).Value = outarr(k, 1)
' Cells(k + 50, 3).Value = outarr(k, 2)
Next k
Cells(50, 1).Value = outarr_conc_1
Cells(50, 2).Value = outarr_conc_2
Cells(50, 3).Value = outarr_conc_3
End Sub