Hi!
i'm trying to creat a macro that looks in column A and B. after that it check if column A have the same file name as B if not it will mart with the color red. and same with the B column.
But i dosent work. 
Sub Kontroll()
Dim Name1 As String
Dim Name2 As String
Dim iRow() As Integer
Dim iRows() As Integer
Dim i As Integer
Dim j As Integer
iRow = Sheets("Kontroll").Range("A2").CurrentRegion.Rows.Count
iRows = Sheets("Kontroll").Range("B2").CurrentRegion.Rows.Count
For i = LBound(iRow) To UBound(iRow)
For j = LBound(iRows) To UBound(iRows)
Name1 = Sheets("Controll").Range("A" & i).Value
Name2 = Sheets("Controll").Range("B" & j).Value
If Name1 <> Name2 Or Name2 <> Name1 Then
Sheets("Controll").Range.Range("A" & j).Interior.Color = 255
End If
Next j
Next i
End Sub
thx in advance
Bookmarks