# move array from the last dimention

Hi,

Please kindly assist how can we move emelemnts of an array one step to the right?
i.e.

arr=1,2,3,4,5,empty

output desired:
arr=empty,1,2,3,4,5

Thanks.
###### Who is Participating?

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Billing EngineerCommented:
dim l as long
dim s as long

s = arr(ubound(arr))
for l = ubound(arr) to lbound(arr)+1
arr(l) = arr(l-1)
next
arr(lbound(arr)) = s

Experts Exchange Solution brought to you by

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Author Commented:
got it!!

For x = UBound(Arr_Req) To i + 1 Step -1
Arr_Req(x) = Arr_Req(x - 1)
Next x
Thanks!
I don't think that would actually work.

You would need to do something like this
dim l as long
dim s as long

s = arr(UBound(arr))
previousNew = arr(l)
For l = LBound(arr) To UBound(arr) - 1
previousOld = arr(l + 1)
arr(l + 1) = previousNew
previousNew = previousOld
Next
arr(LBound(arr)) = s

Cheers,

Leo