dj44
11-24-2017, 01:45 PM
folks good day,
is there a way to make another shortcut loop to go wth my array
as you can see
i would like to step by 50
so i did the multiplication
Dim n: n = 50
oDestination = Array("A1", "A" & n, "A" & 2 * n, "A" & 3 * n, "A" & 4 * n, "A" & 5 * n, "A" & 6 * n, "A" & 7 * n, "A" & 8 * n, "A" & 9 * n)
but it does look very confusing to the layman
with my A's and n's
so the result is actually meant to be this in the array ("A1","A50",A100,A150....")
these are my cell ranges
is there a way to make another shortcut loop to go wth my array
as you can see
i would like to step by 50
so i did the multiplication
Dim n: n = 50
oDestination = Array("A1", "A" & n, "A" & 2 * n, "A" & 3 * n, "A" & 4 * n, "A" & 5 * n, "A" & 6 * n, "A" & 7 * n, "A" & 8 * n, "A" & 9 * n)
but it does look very confusing to the layman
with my A's and n's
so the result is actually meant to be this in the array ("A1","A50",A100,A150....")
these are my cell ranges