Using Split function with Cells, Range, Rows.count, and xlup on excel-vba <p>Will this code work?</p> <pre><code>lr = RD.Cells(Rows.Count, 8).End(xlUp).Row wArray() = Split(RD.Range(Cells(2, 8), Cells(Rows.Count, 8).End(xlUp).Row)) RD.Cells(2, 8).Value = wArray(0) RD.Cells(2, 9).Value = wArray(1) </code></pre> <p>I want the code to go through each of the cells in the range and split the data in that range and put the 2nd string on the cell next to it. Like for example, I have a <code>A1:A15</code> cell range that has the cell value of "01/01/2015 09:43 GMT", after I run the the code, I expect that "01/01/2015" will remain at range A1:A15 while "09:43" will be moved to cell range <code>B1:B15</code>. I have tried the same code by defining a single cell on the <code>Split(RD.Cells)</code> function and it worked beautifully. Now I need it to keep on going on the next row as long as that row has an input.</p>