j = 1: r = 2: x = 1 While Workbooks(TgtBook).Sheets.Count >= j k = 2: If Workbooks(TgtBook).Sheets(j).Name Like "変更履歴*" = False Then wSht.Cells(r + j - 2, 1) = Workbooks(TgtBook).Sheets(j).Name While MSht.Cells(i, k) <> "" If wSht.Cells(x, k) = Workbooks(TgtBook).Sheets(j).Range(MSht.Cells(i, k)) Then wSht.Cells(r + j - 2, k) = "○" Else wSht.Cells(r + j - 2, k) = "×" End If k = k + 1 Wend End If j = j + 1 Wend r = r + 1 Workbooks(TgtBook).Close SaveChanges:=False i = i + 1 Wend End Sub