Hi there,
I want to use the LEFT function in VBA. But it doesn't work and I cannot find the solution on internet.
Can you help, please?
here is my code:
I want to use the LEFT function in VBA. But it doesn't work and I cannot find the solution on internet.
Can you help, please?
here is my code:
Code:
Sub automatisch()
Dim landcode As String
If Range("A1").Value = 2 And Left(range.("B1").Value, 2) = "Ha" Then
Range("C1").Value = "OK!"
Else: Range("C1") = "A1 is not 2 and/or B1 doesn't start with 'Ha'."
End If
End Sub