Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 25
Default 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,
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,986
Default 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,

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 25
Default 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,

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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,



  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,202
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA commands Love2Learn Excel Discussion (Misc queries) 4 January 28th 09 07:31 AM
IF commands ryan Excel Worksheet Functions 1 August 17th 07 02:10 AM
meaning of : IF(Switch; Average(array A, array B); array A) DXAT Excel Worksheet Functions 1 October 24th 06 06:11 PM
DDE Commands Newby Excel Discussion (Misc queries) 0 October 17th 05 07:22 PM
Help with "if-then"/look up commands or what ever you think is best. [email protected] Excel Discussion (Misc queries) 2 March 16th 05 08:25 PM


All times are GMT +1. The time now is 07:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"