Return items in array

shadal · Aug 15th 2016

Hello,

Seems this should be a pretty simple task but it's suffocating me...

My array consists of...

I need a loop that will return

tempVar1 = Section1
tempVar2 = 24

Loop

tempVar1 = Section 2
tempVar2 = 47

Loop - etc, etc...

I've tried LEFT, SPLIT... Not having luck though..

**cytop** · Aug 15th 2016

Re: Return items in array

Assuming a 1 dimension array where the commas in your example delimit the individual elements (It always helps to be very clear when explaining things)

Code

Sub Test()


   Dim z                As Variant
   Dim y                As Long


   z = Split("Section1|24,Section2|47,Section3|69,Section4|103,Section5|145", ",")


   For y = LBound(z) To UBound(z)


      Debug.Print Split(z(y), "|")(0) & vbTab;
      Debug.Print Split(z(y), "|")(1)
   Next


End Sub

Display More

shadal · Aug 15th 2016

Re: Return items in array

Thank you, I knew it was simple!

Return items in array

Participate now!

Share