Using the string function Left$ is faster and that may be important if it is
run in a loop.

Left$(Cells(variable, 1), 9)


RBS


"Jacob Skaria" wrote in message
...
Since the same function is available with VBScript you can use it
directly.
For example.

Msgbox Left("John",2) returns "Jo"

If this post helps click Yes
---------------
Jacob Skaria


"LuisE" wrote:

Application.WorksheetFunction.Left(Cells(variable , 1 ) ,9)

How can i get the formula above to work?
Thanks in advance.