Hello guys,
I have made following code
that check several statements..
if the value in column "H" have value"MLY" then check column if value is "I" if the value is "MLY" and if the value is more 0 in column "B" and "AB" same row.
For the same row but column "A" make a string of the value (myFound)
now my question:
from the value I want to find all occurrences in same column and make them a color.
see code
Could someone help me?
Thank you in advance
I have made following code
that check several statements..
if the value in column "H" have value"MLY" then check column if value is "I" if the value is "MLY" and if the value is more 0 in column "B" and "AB" same row.
For the same row but column "A" make a string of the value (myFound)
now my question:
from the value I want to find all occurrences in same column and make them a color.
see code
Code:
Sub mytest()
For i = 2 To ActiveSheet.UsedRange.SpecialCells(xlCellTypeLastCell).Row
If Cells(i, "H") = "MLY" And Cells(i, "I") = "MLY" And Len(Cells(i, "B")) <> 0 And Cells(i, "AB") <> 0 Then
myFound= Cells(i, "A").Value
End If
Next i
End Sub
Could someone help me?
Thank you in advance