View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Eliezer Eliezer is offline
external usenet poster
 
Posts: 12
Default Arrays in Excel VBA

I have a loop that has a number of strings (unknown until
runtime) that I need to capture in an array. I know it
won't be more than 44 strings, but if I declare the array
for size 44 - I end up with a bunch of empty strings in my
array.

Do Until...
repName 'that's my string value I need to insert into
the array
Loop

How do I declare / populate the array with only
actual "repName"s (i.e. not when "repName" = "")?

Thanks!
Eliezer