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

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

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.

Thank you

it is working now.

Moiz