Advertisement
gorghino

Untitled

Jun 11th, 2020
1,425
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
VB.NET 1.37 KB | None | 0 0
  1. Sub ListAllCombinations()
  2. 'Updateby Extendoffice
  3. Dim xDRg1, xDRg2, xDRg3 As Range
  4. Dim xRg  As Range
  5. Dim xStr As String
  6. Dim xFN1, xFN2, xFN3 As Integer
  7. Dim xSV1, xSV2, xSV3 As String
  8. Set xDRg1 = Range("A1:A7")  'First column data
  9. Set xDRg2 = Range("B1:B3")  'Second column data
  10. Set xDRg3 = Range("C1:C4")  'Third column data
  11. xStr = "-"   'Separator
  12. Set xRg = Range("I1")  'Output cell
  13. Set xRg2 = Range("J1")  'Output cell
  14. Set xRg3 = Range("K1")  'Output cell
  15. For xFN1 = 1 To xDRg1.Count
  16.     xSV1 = xDRg1.Item(xFN1).Text
  17.     For xFN2 = 1 To xDRg2.Count
  18.         xSV2 = xDRg2.Item(xFN2).Text
  19.       For xFN3 = 1 To xDRg3.Count
  20.         xSV3 = xDRg3.Item(xFN3).Text
  21.         xRg.Value = xSV1 & xStr & xSV2 & xStr & xSV3
  22.         xRg2.Value = xSV1 & xStr & xSV2 & xStr & xSV3
  23.         xRg3.Value = xSV1 & xStr & xSV2 & xStr & xSV3
  24.         Set xRg = xRg.Offset(1, 0)
  25.         Set xRg2 = xRg2.Offset(1, 0)
  26.         Set xRg3 = xRg3.Offset(1, 0)
  27.        Next
  28.     Next
  29. Next
  30.  
  31. Set Range1 = Range("I1:I84")
  32. For xFN1 = 1 To Range1.Count
  33.     Range1.Item(xFN1).Value = Split(Range1.Item(xFN1).Text, "-")(0)
  34. Next
  35.  
  36. Set Range2 = Range("J1:J84")
  37. For xFN1 = 1 To Range2.Count
  38.     Range2.Item(xFN1).Value = Split(Range2.Item(xFN1).Text, "-")(1)
  39. Next
  40.  
  41. Set Range3 = Range("K1:K84")
  42. For xFN1 = 1 To Range3.Count
  43.     Range3.Item(xFN1).Value = Split(Range3.Item(xFN1).Text, "-")(2)
  44. Next
  45.  
  46. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement