The help in my MS VB Editor help doesn't bring any MS VB Language Reference
Content so can someone help me on where can I get help on commands I can use
to manipulate arrays on my Excel macros?

Thanks in advance,

Here's one place:

http://www.cpearson.com/excel/returnin.htm

"Francisco" wrote:

> The help in my MS VB Editor help doesn't bring any MS VB Language Reference
> Content so can someone help me on where can I get help on commands I can use
> to manipulate arrays on my Excel macros?
>
> Thanks in advance,

Thanks, but are there any additional commands I can use to manipulate arrays.
Like find whith out having to make a loop or any others.


"JLGWhiz" wrote:

> Here's one place:
>
> http://www.cpearson.com/excel/returnin.htm
>
> "Francisco" wrote:
>
> > The help in my MS VB Editor help doesn't bring any MS VB Language Reference
> > Content so can someone help me on where can I get help on commands I can use
> > to manipulate arrays on my Excel macros?
> >
> > Thanks in advance,

beyond erase and redim, I don't think there are any vb/vba commands specific
to the variable type array. For the most part, you have to loop through
your arrays.

--
Regards,
Tom Ogilvy


"Francisco" <(E-Mail Removed)> wrote in message
news:8FCF915D-1DB2-4CF4-B8CE-(E-Mail Removed)...
> Thanks, but are there any additional commands I can use to manipulate
> arrays.
> Like find whith out having to make a loop or any others.
>
>
> "JLGWhiz" wrote:
>
>> Here's one place:
>>
>> http://www.cpearson.com/excel/returnin.htm
>>
>> "Francisco" wrote:
>>
>> > The help in my MS VB Editor help doesn't bring any MS VB Language
>> > Reference
>> > Content so can someone help me on where can I get help on commands I
>> > can use
>> > to manipulate arrays on my Excel macros?
>> >
>> > Thanks in advance,

> Thanks, but are there any additional commands I can use to manipulate
> arrays. Like find whith out having to make a loop or any others.

It would help if you gave some more details about the type of manipulations
you had in mind and to what (data) type of arrays.

If you are talking about String arrays, you might find the Filter function
useful.

http://msdn2.microsoft.com/en-us/library/aa262744(VS.60).aspx

Rick