Arrays

Hi everyone:

1- I have two arrays Arr1 and Arr2 of sizes 100 and 25 respectively. I want
to send the last 25 elements of Arr1 into Arr2, for example elements 76 to
100. Is there any way of doing this without loops, like for example;
Arr2=Arr1(76)

2- What is I want to pass the last 25 elements of Arr1 to another routine
sub first(Arr2)
.
.
end sub

call first(Arr1(76))
is this possible?

Thanks for all your help.

Bob


.

Relevant Pages

  • How to set up an undetermined number of outer for next loops
    ... How do you write code to set up an undetermined number out outer loops ... number for next loops to fill a string that is passed to a sub to xor ... I know how to set up an unknown SQL string but not sure how to code ...
    (microsoft.public.access.modulesdaovba)
  • Re: recalculating RAND() inside a VBA loop
    ... Calling the function from another function or sub wouldn't be a problem. ... It'll be a problem when the function originates in a cell on a worksheet. ... Dim loops As Integer ...
    (microsoft.public.excel.programming)
  • Re: code to hide rows based on criteria - but without looping
    ... "Don Guillett" wrote: ... Sub deleteblankrows() ... For Each cell In Range ... What I've read elsewhere is to avoid Loops whenever possible. ...
    (microsoft.public.excel.programming)
  • RE: Iterate through the autofiltered rows
    ... This works on a filtered range in column A and loops through the visible rows ... Sub Sonic() ... Dim MyRange as Range ...
    (microsoft.public.excel.programming)
  • Re: How to add series to a chart using a macro
    ... The last three loops give Rows above 64k. ... End Sub ... Dana DeLouis ... 10 series then I will tweak the code for 240 series. ...
    (microsoft.public.excel.programming)