Array commands
 

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,

Array commands
 

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,

Array commands
 

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,

Array commands
 

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" wrote in message
...
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,

Array commands
 

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/lib...44(VS.60).aspx

Rick