I am try to run this code but its showing error
i want to run after first step of i loop go to next step of j loop
how to run this any one plz help me
Private Sub test()
Dim Col_List As Variant, To_List As Variant
Dim j As Long,i As Long
To_List = Array("Product Value", "Product Description", "UOM", "Mrp", "Value")
Col_List = Array("Product Value", "Product Description", "UOM", "[ ]", "Value")
For j = LBound(To_List) To UBound(To_List)
For i = LBound(Col_List) To UBound(Col_List)
Rest = To_List(j) & "/" & Col_List(i)
Next j
Next i
End Sub
i want to run after first step of i loop go to next step of j loop
how to run this any one plz help me
Private Sub test()
Dim Col_List As Variant, To_List As Variant
Dim j As Long,i As Long
To_List = Array("Product Value", "Product Description", "UOM", "Mrp", "Value")
Col_List = Array("Product Value", "Product Description", "UOM", "[ ]", "Value")
For j = LBound(To_List) To UBound(To_List)
For i = LBound(Col_List) To UBound(Col_List)
Rest = To_List(j) & "/" & Col_List(i)
Next j
Next i
End Sub