Splitting Columns in Excel

If you’re like me and get frustrated with Excel’s lack of column splitting, run this macro to split them. Sub SingleToMultiColumn() Dim rng As Range Dim iCols As Integer Dim lRows As Long Dim iCol As Integer Dim lRow As Long Dim lRowSource As Long Dim x As Long Dim wks As Worksheet Set rng […]