LEFT function error (excelVBA) - Wrong number of arguments or invalid property assignment

Hi

im getting the above error when i use the left function to extract characters in my code and
think its very strange. has anyone else had this problem?

Heres is an excerpt of a select case statement where its used. The code is part of a worksheet change routine
and the target cell value has already been checked to make sure its not blank as shown, so i dont know why i get
the errors. I tried the RIGHT function which doesnt throw up an error but is unsuitable for this task.

All help is appreciated.

Please Login or Register  to view this content.

Izandol...youre a genius!

Thank you that worked perfectly. Im using reflections for regis graphics (virtual terminal software), but there is no other variable named left
The only occurrence of "Left" is as a substring of one of the reflections commands - "rcVtLeftKey". Could this by itself be the culprit?

Have a nice weekend