Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 11-25-2013, 02:44 PM
omahadivision omahadivision is offline How do you loop through an array with some empty values? Windows 7 32bit How do you loop through an array with some empty values? Office 2007
Novice
How do you loop through an array with some empty values?
 
Join Date: Oct 2012
Posts: 28
omahadivision is on a distinguished road
Default How do you loop through an array with some empty values?

Hello,



This seems like a very simple question, but I can't figure it out. I am looping through a string array, looking for the part of the array which contains a "/" mark

Code:
i=0
Do Until i > 10
   If splitslash(i) Like "*[/]*" Then
   Range("H4").Value = splitslash(i)
       End If
    i = i + 1
    Loop
    End If
The only problem is that I don't know how many values are in the array, only that they are between 0 and 11. I always get a "subscript out of range" error message once the array reaches empty space. I've tried using null qualifiers and even filling the array with arbitrary values, but I'm totally stumped.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you loop through an array with some empty values? CORREL function with a constant array j2b3 Excel 3 01-30-2013 01:49 AM
How do you loop through an array with some empty values? 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
How do you loop through an array with some empty values? Complex array formula andrei Excel 9 02-03-2012 03:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:20 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft