Sub test5()
'概要
' 作成済ベースコンフィグに、拠点ごとの変更部位を太文字
' にした部位を、パラメータ番号に置き換える
'
'------------------------------------------
'初期パラメータ
' 先頭行
row_start = 2
' 終了行
row_end = 114
'------------------------------------------
Dim arr_word() As String
Dim arr_bold() As String
Dim arr_str() As String
Dim arr_paramnum_row(100) As Integer
Set ws2 = ThisWorkbook.Worksheets("sheet2")
Set ws3 = ThisWorkbook.Worksheets("sheet3")
k3 = 0
For i_row = row_start To row_end
Str1 = Cells(i_row, 1).Value
ReDim arr_word(Len(Str1))
ReDim arr_bold(Len(Str1))
ReDim arr_str(Len(Str1))
ReDim arr_str_bold(Len(Str1))
'1行分文字列を読み込み、①文字自体②太字情報を配列に取り込む
For j = 0 To Len(Str1) - 1
arr_word(j) = Cells(i_row, 1).Characters(j + 1, 1).Text
arr_bold(j) = Cells(i_row, 1).Characters(j + 1, 1).Font.Bold
Next j
'空白区切りの文字列(文字、太字情報)を配列に収納する
'太字の判断は先頭文字の太字情報で判断する
m = 0
len_arr_str = 0
f_moji = 0
For k = 0 To Len(Str1) - 1
If arr_word(k) <> " " Then
arr_str(m) = arr_str(m) & arr_word(k)
len_arr_str = len_arr_str + 1
f_moji = 1
End If
If ((arr_word(k) = " ") And (f_moji = 1)) Or k = Len(Str1) - 1 Then
arr_str_bold(m) = arr_bold(k - len_arr_str + 1)
m = m + 1
f_moji = 0
len_arr_str = 0
End If
Next k
'太字文字列を、パラメータ名通番に置き換え
strout = ""
For k2 = 0 To m - 1
If arr_str_bold(k2) = False Then
strout = strout & arr_str(k2) & " "
ElseIf arr_str_bold(k2) = True Then
k3 = k3 + 1
strout = strout & "{★★" & k3 & "★★} "
arr_paramnum_row(k3) = i_row
End If
Cells(i_row, 2) = strout
Next k2
For s1 = 1 To k3
ws3.Cells(s1 + 2, 1) = "{★★" & s1 & "★★} "
'MsgBox Cells(arr_paramnum_row(s1), 1).Value
' ws3.Cells(s1 + 2, 2) = ws2.Cells(29, 1)
'ws3.Cells(s1 + 2, 2) = ws2.Cells(arr_paramnum_row(s1), 1)
Next s1
Next i_row
For s2 = 1 To k3
ws3.Cells(s2 + 2, 2) = ws2.Cells(arr_paramnum_row(s2), 2)
Next s2
End Sub