Hi, Im using the new excel and i have trouble with some formulas, LEFT, for example is not working, I cannot use my spreadsheets and other code in my userform, is there a library i should use?
Printable View
Hi, Im using the new excel and i have trouble with some formulas, LEFT, for example is not working, I cannot use my spreadsheets and other code in my userform, is there a library i should use?
What version of Excel 2007 are you using? Beta1, Beta2, Beta2 Tech Refresh or the RTM version that you would have got from an MSDN subscription?
And are you having issues with LEFT as a worksheet formula, or just in code?
thanks, its beta 2 and only in code
Okay, I'm not sure I'll be able to help you, as I don't have the plain Beta2 version installed (I'm using the RTM version.)
Having said that, can you post the offending code? Maybe someone else can come along who does have that version, or maybe you have a syntax error that is not Beta related at all.
im sure it is cause its running on 2003, the alert points exactly on the sentence :
left(mystring,2)
Running on 2003 or 2007? It's one or the other. Also, post your code and the exact error message received, along with pointing out any highlighted lines or special circumstances.
Zack, I think he's saying that it is working on 2003, but is not working on 2007. ;)
Ah. I'd still like to see the code. Also, the OP should check the Left(), Left$(), Right(), Right$(), Mid() & Mid$() functions.
Agreed, Zack.
Mukako, it would also be nice to know what the value of "mystring" is when it fails.