View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
Posts: 2,452
Default WorksheetFunction.Left problem

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

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


"Jacob Skaria" wrote in message
Since the same function is available with VBScript you can use it
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.