Hi
variable=len(variable_2)
also use Mid without application.worksheetfunction

--
Regards
Frank Kabel
Frankfurt, Germany

"Moiz" schrieb im Newsbeitrag
...
I need to manipulate text variables using Visual Basic programming

what is thestatement for:

Len - length of variable
Mid

I tried:

variable = Application.WorksheetFunction.Len (Variable)
but it does not work.

Moiz