In the excel file as above, I want each words in the Column one (12 totally) and each words in the Column two (4 totally) to be combined into phrases generated in the Column three. I should get 12*4 = 48 phrases. Using the codes I wrote as below, only less than 30 are there with some null-value cells. Please tell me why I couldn’t reach 48. Thank you.
Sub WordsCombiner() For i = 1 To 12 For m = 1 To 4 Cells(i * m, 3).Value = Cells(i, 1).Value Cells(m, 2).Value Next Next End Sub
The following is the original words:
from the on this Oh and FYI prices accurate and items in
as time of publication