2. Create a VBA array function called ShiftVector(rng.n) with arguments for a range (mg) and in that will

shift the elements of an (m x 1) vector up by n rows. The first n rows of the range rng will "wrap around"

and appear at the bottom of the resulting vector. IMPORTANT: Your array function should be capable

of accommodating strings and data types other than just numbers.

1

2 hi

6789&wN-

3

4 hey

5

8 yo

1-ShiftVector(A1:A9,3)

/output by

END

5

3

9

7

2

import

START

input n

✓

Count rows nr

Ctri-Shift-Enter

Here is a flow chart that you can implement in your ShiftVector function:

-rag

tis(nr-n))

+ b(:) = rng(i+1)

is ar

i-nr-1-1

5

3

OF

3

1234SSTE a

yo

2

2 hi

4 hey

5

6

8 yo

1 hey

#example if

5

9

7

yo

hi

В

7

2

1

6(nr_n+1 →nr)

= [6(79)]

this will become

b(1-ar-n).

=[6(1+6)]

+ 6(1) = (ng(i-nr +n)

"Remember that if you don't have Office 365, you'll need to press Ctrl-Shift-Enter when you enter this

function in Excel!