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)
--ron