Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA commands | Excel Discussion (Misc queries) | |||
IF commands | Excel Worksheet Functions | |||
meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
DDE Commands | Excel Discussion (Misc queries) | |||
Help with "if-then"/look up commands or what ever you think is best. | Excel Discussion (Misc queries) |