loop through array with index in vba and get element at specific index

Question

I am right now trying something like this

Dim myAddress() As String
myAddress= Split("4th Street NW Washington, DC")

For intI = 1 To UBound(myAddress)
     `how can i access myAddress[intI+1] from here?
Next intI

Leo Chapiro · Accepted Answer · 2017-08-08 14:30:23Z

5

Try this:

Dim myAddress() As String
myAddress= Split("4th Street NW Washington, DC")

For intI = 1 To UBound(myAddress)
    Console.WriteLine(myAddress(intI))
Next intI

edited Aug 8, 2017 at 14:30

answered Apr 12, 2013 at 14:50

Leo Chapiro

14k8 gold badges67 silver badges95 bronze badges

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

4 Comments

user391986 Over a year ago

thanks that does work the problem within that loop how would i access the +1 or next element

HansUp Over a year ago

VBA defaults to 0 as the index of the first array element.

user391986 Over a year ago

awesome! so I can do myAddress(intI+1)? is there a way to check if it's a valid index?

HansUp Over a year ago

Valid index values are >= LBound(myAddress) And <= UBound(myAddress)

Collectives™ on Stack Overflow

loop through array with index in vba and get element at specific index

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related