every possible combination of the contents of 2 columns in excel

by

this should do it:

Sub combineTwoCol()

    ' i,j,k are counters for first col, second col and the answer col in order.
    k = 1
    For i = 1 To 1000
        For j = 1 To 10
            Cells(k, "C").Value = Cells(i, "A").Value
            Cells(k, "D").Value = Cells(j, "B").Value 
            k = k + 1
        Next j
    Next i
End Sub

edited: you should notice that i assumed you have only those two columns is the file, if not change “A” and “B” to the corrosponding columns you need. and “C” and “D” to where you want the two output columns to be.

also if the 10 and 1000 are just examples and not really the values you can always find them dynamically like this:

'this return to the variable the last row in column A
LastRowColA = Range("A65536").End(xlUp).Row

and replace 1000 with LastRowColA

More Related Contents:

  1. How do you change the value of a cell in excel by clicking on it using VBA? [closed]
  2. Excel Number Separation [closed]
  3. excel vba compare & copy worksheets from 2 excel files
  4. VBA Stuck after certain loop
  5. How do I use FileSystemObject in VBA?
  6. Is the . in .Range necessary when defined by .Cells?
  7. How to return a result from a VBA function
  8. Run Excel Macro from Outside Excel Using VBScript From Command Line
  9. Importing text file into excel sheet
  10. Error: “Could Not Find Installable ISAM”
  11. Filling any empty cells with the value above
  12. Properly Handling Errors in VBA (Excel)
  13. Password hash function for Excel VBA
  14. Aggregate, Collate and Transpose rows into columns
  15. VBA Excel sort range by specific column
  16. Select method of Range class failed via VBA
  17. Delete cells in an Excel column when rows = 0
  18. Comparison of Dictionary, Collections and Arrays
  19. How to add events to dynamically created controls (buttons, listboxes) in Excel VBA userform
  20. How to copy data from closed workbooks (keeping them closed) into master workbook using VBA?
  21. VBA paste as values – how to
  22. Excel: the Incredible Shrinking and Expanding Controls [closed]
  23. How to send email to multiple recipients with addresses stored in Excel?
  24. What are the benefits of using Classes in VBA? [closed]
  25. Writing a VLOOKUP function in vba
  26. Handle cancellation of InputBox to select range
  27. Type Mismatch in Loop to scan Outlook Messages [duplicate]
  28. VBA: How to combine two ranges on different sheets into one, to loop through
  29. How to protect Excel workbook using VBA?
  30. How to get the range of the visible rows after applying an advanced filter in Excel (VBA)

Leave a Comment