View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
Posts: 5,651
Default WorksheetFunction.Left problem

On Wed, 8 Apr 2009 22:06:01 -0700, LuisE wrote:

Application.WorksheetFunction.Left(Cells(variab le , 1 ) ,9)

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

You cannot as written.

Left is NOT a member of the WorksheetFunction object.

VBA includes Left as a built-in function. Hence there is no reason for it also
to be included in the WorksheetFunction object.

You can discover this by looking at the prompts that occur when you type
commands in VBA; using the object browser; or using the HELP facility.

Instead, try:

Left(Cells(variable , 1 ) ,9)