View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
Posts: 8,520
Default 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.