Do a for loop with just some array elements

Question

I guess this is a easy one but I can't figure it out.

I have an array with multiple items, as it follows:

slds = Array(3, 15, 27, 39, 51, 87, 74, 89, 11, 45, 57, 24)

I want to do a For loop using just some items the array, defined by the position, for example, the first 4 elements, but I don't know the correct syntax for it. Something like

For slds(0) to slds(3) 'do some...

Any ideas?

For i = lBound(slds) to Lbound(slds) + 3 Then use slds(i) to refer to the item. — Scott Craner
– Scott Craner, Commented Dec 30, 2015 at 14:41

Community · Accepted Answer · 2017-05-23 12:31:13Z

2

Assuming a typical zero-based array in VBA:

For i = 0 To 3
    'do stuff
    Debug.Print slds(i)
Next

Here you are indicating you want index 0 to 3, or the first 4 elements.

If you can't be certain of zero-based, you'd use
For i = lBound(slds) to Lbound(slds) + 3as mentioned by Scott Craner

edited May 23, 2017 at 12:31

CommunityBot

11 silver badge

answered Dec 30, 2015 at 14:41

Daniel

13.1k3 gold badges39 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

brettdj · Accepted Answer · 2015-12-31 07:06:53Z

2

Or you could just Redim the array to capture the first x values.

For loop retained in case you still want to loop.

Sub a()
Dim slds
Dim lngCnt As Long
slds = Array(3, 15, 27, 39, 51, 87, 74, 89, 11, 45, 57, 24)
ReDim Preserve slds(1 To 3)
For lngCnt = 1 To UBound(slds)
    Debug.Print slds(lngCnt)
Next
End Sub

answered Dec 31, 2015 at 7:06

brettdj

55.9k16 gold badges120 silver badges178 bronze badges

Collectives™ on Stack Overflow

Do a for loop with just some array elements

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related