On Wed, 18 Aug 2004 12:09:00 +0100, Moiz wrote:

I need to manipulate text variables using Visual Basic programming

what is thestatement for:

Len - length of variable

x = Len(y$) 'x is a numeric variable

Mid

x$ = Mid(y$, start, length) 'start and length are both integers

I tried:

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

That's because they're not worksheet functions.
--
auric underscore underscore at hotmail dot com
*****
You can do it your own way, if it's done just how I say.