Hi, I'm new to the forum and really desperate.

I've got the following piece of code (I've been a Java coder for years) but I get an error and I really don't know what I'm doin' wrong.

Here it is:

Sub myMacro()
    For i = 1 To 8
        For j = 1 To 52
            Cells(j, 3).Value = "=IF.ERROR(FIND(Cells(" + i + ",1),Cells(" + j + ",2);Cells(" + i + ",1))"
        Next
    Next
End Sub
Might I get some help? This is driving me crazy, really!

And these are bits from the table:

1st column
DC SHOES
ETNIES
ELEMENT
SANTA CRUZ


2nd column
DC SHOES SUDADERA NIŅO
DC SHOES PANTALONES NIŅO
DC SHOES ACCESORIOS CHICO BACKPACK
ETNIES PANTALONES CHICO
ETNIES PANTALONES CHICO
ETNIES PANTALONES CHICO

I'm trying to exctract the first column from the second and putting the brand in a 3rd column.

Thanks in advance!!!!