Left function in a Select Case Macro

I am trying to put together a Select Case macro and am having problems with the Left function on the first line. If i don't have it there the macro works fine. Does anyone have any ideas?

Please Login or Register  to view this content.

Many Thanks

Its ok, sorted now.

Please Login or Register  to view this content.