WorksheetFunction.Left problem
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.
