Loop through Array then Offset Range by given Value

[rawku123]

How do I use a loop to offset a range on each looped Array?
This is what I have:

Please Login or Register  to view this content.

But then I need to offset A5:AD5 by a row value of 4 each time it completes a loop. Any ideas ?

[rawku123]

To better explain my problem I have this:-

Please Login or Register  to view this content.

This is poo, lol if i were to complete it like this i'd have to do that 30 more times :S

[jindon]

Should be like

Please Login or Register  to view this content.

[protonLeah]

A string array of, say, 30 range addresses starting from "A5:AD5" and incrementing by four:

Please Login or Register  to view this content.

---

Please Login or Register  to view this content.

[rawku123]

Thanks everyone for the replies. One last question though.
How do I increase this by 1?

Please Login or Register  to view this content.

[jindon]

What do you mean by

How do I increase this by 1?

[rawku123]

What do you mean by

Ah crap my apologies that was written wrong lol.

Please Login or Register  to view this content.

I want linerng(1) to increase by 1

[jindon]

Is it related to the code I posted? or new question?

Anyway your code doesn't make sense to me, so you need to explain what you are really trying to do in words.

[rawku123]

No this is a new code but part of the bigger picture.

Please Login or Register  to view this content.

Lol my apologies again i have no idea how to word or describe it

[jindon]

then perhaps

Please Login or Register  to view this content.

[rawku123]

unfortunately it doesn't work

[jindon]

"Doesn't work" is the worst response.

How is it not working?

Since you are posting just a part of the code one by one, it is too hard to even guess.

[rawku123]

You changed the post to from

Set linerngints(iee) = Application.Inersect(myRange, linerng(i))
to
Set linerngints(iee) = Application.Inersect(myRange, linerng(iee))

But yes (iee) does work XD thankyou for being patient.