Wie kan ich zwei Cellen im Qelkode vergleichen?
If Cells(ActiveCell.Row, ActiveCell.Column - 2).Font.ColorIndex = 3 = Range_("M29") Then
Vielen dank Gerhard
Sub Makro1()
If Cells(ActiveCell.Row, ActiveCell.Column + 1).Font.ColorIndex = 3 Then Else Exit Sub
If Cells(ActiveCell.Row, ActiveCell.Column).Text = Cells(ActiveCell.Row, ActiveCell.Column + 1).Text Then
MsgBox " Jetzt hier", 64
Else
End If
End Sub
Sub Makro2()
If Cells(ActiveCell.Row, ActiveCell.Column + 1).Font.ColorIndex = 3 And Cells(ActiveCell.Row, ActiveCell.Column).Text = Cells(ActiveCell.Row, ActiveCell.Column + 1).Text Then MsgBox " Übereinstimmung", 64 Else Exit Sub
End Sub