Archive for the ‘Development’ Category

Splitting Columns in Excel

Posted by Nicole on October 21, 2009 in Development | No Comments

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 […]

Read More