Private Sub Workbook_Open() MoveBoot = 1 For RowBoot = 1 To 100 For ColumnBoot = 1 To 100 If (Trim(Worksheets(1).Cells(RowBoot, ColumnBoot).Value) <> Trim(Worksheets(2).Cells(RowBoot, ColumnBoot).Value)) Then Worksheets(3).Cells(MoveBoot, 1).Value = "行号:" & RowBoot & ";列号:" & ColumnBoot Worksheets(3).Cells(MoveBoot, 2).Value = "表一内容:" & Worksheets(1).Cells(RowBoot, ColumnBoot).Value Worksheets(3).Cells(MoveBoot, 3).Value = "表二内容:" & Worksheets(2).Cells(RowBoot, ColumnBoot).Value MoveBoot = MoveBoot + 1 End If Next Next End Sub