Array commands

[Guest]

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,

 

[Guest]

Here's one place:

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

 

[Guest]

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.

 

[Tom Ogilvy]

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.

 

[Rick Rothstein \(MVP - VB\)]

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