How do you loop through an array with some empty values?

BobBridges · #1 11-27-2013, 10:20 AM

(Further explanation:) Omaha, Paul included an Exit statement, which is correct if you want to stop once you find "the" value with the slash in it. My version assumes there are multiple values you want to save, and keeps looking through the whole array.

As for the starting point of the array, that depends on how you defined the array. What Paul's saying is that if you define an array like this:

Code:

Dim splitslash(10)

...then VBA will define splitslash with 11 entries running from splitslash(0) to splitslash(10). I'm used to programming in other languages that assume 1 as the bottom entry, so I keep forgetting how VBA does it; to avoid the uncertainty I usually specify both limits, like this:

Code:

Dim splitslash(0 to 10)

...or "1 to 10" or "5 to 23" or whatever suits my purpose.

But no matter what you specified when you defined the array, you can always have your program use the LBound function, which mirrors UBound:

Code:

For i = LBound(splitslash) To UBound(splitslash)

macropod · #2 11-27-2013, 02:30 PM

Quote:

Originally Posted by BobBridges

What Paul's saying is that if you define an array like this:

Code:

Dim splitslash(10)

Actually, I was thinking more in terms of:

Code:

Dim splitslash
splitslash = Array("one", "two", "three")

omahadivision · #3 11-28-2013, 10:49 AM

Thanks guys! I now have plenty of methods to try

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
CORREL function with a constant array	j2b3	Excel	3	01-30-2013 01:49 AM
Convert String Array to Integer Array from a User Input?	tinfanide	Excel Programming	4	12-26-2012 08:56 PM
Apparently empty (blank) cells aren't empty	daymaker	Excel	3	03-08-2012 03:41 PM
How to reserve an array in a public function?	tinfanide	Word VBA	2	02-27-2012 06:51 AM
Complex array formula	andrei	Excel	9	02-03-2012 03:40 AM