LEFT function - error 1004 ?

**Lukael** · 04-25-2014, 07:37 AM

HI,

what's wrong with this code :

Please Login or Register  to view this content.

I get an "Application-defined or object-defined error". Is this because LEFT function cannot be used in same way with VBA ?

I need that in VBA, please help !

**6StringJazzer** · 04-25-2014, 07:43 AM

VBA doesn't care what that formula is, because you are putting a formula into a cell (not calling VBA to evaluate that formula). When the formula is not valid, you get an error like the one you mention. But your code works fine for me, except I had to change the ";" to a "," for USA localization. Before I made that change I got the same error.

Can you type that same formula directly into the cell and get it to work?

**Lukael** · 04-25-2014, 07:47 AM

hi,

thanks for response. Yes, I tried that many times, formula works when I type It directly in cell !

**Lukael** · 04-25-2014, 07:51 AM

heyy, wait a minute....

I tried too with , - and It worked. But why ? I'm from Europe, It should work in way I did It. And the tricky part is that It don't work If I enter It with , - directly in cell.

Guess like VBA console is pure English, and then translates It to non-english