コードは以下の通り ----------------------------------------- Dim MyRange2 As Range Dim fukusyoku2 As String Dim 最終行2 As Integer Dim k As Long For k = 1 To 9 If k <> 5 Then 最終行2 = Cells(Rows.Count, 12).End(xlUp).Row fukusyoku2 = Me.Controls("ComboBox" & CStr(k + 6)).Value Set MyRange2 = Columns("L").Find(What:=fukusyoku2) If MyRange2 Is Nothing Then Cells(最終行2 + 1, 12).Value = Me.Controls("ComboBox" & CStr(k + 6)).Value 最終行4 = Cells(Rows.Count, 12).End(xlUp).Row