left function in vba

[mrinal saha]

Hi folks,

I am using the left function in my code but i guess i am getting somewhere wrong because am getting error on that line

If Left(Cells(b, 7).Value, 9) Or Left(Cells(b, 7).Value, 10) = Cells(x, 17).Value Then

thankxx
Mrinal

 

[Sektor]

Left(Cells(b, 7).Value, 9) - No compare.

 

[VoG]

Try

If Left(Cells(b, 7).Value, 9) = Cells(x, 17).Value Or Left(Cells(b, 7).Value, 10) = Cells(x, 17).Value Then