am new to VBA but have been using vb6 for the past few months
I am trying to modify the code in this thread to work on my spread sheet.
the sample spreadsheet that came with the code from that thread worked ok with the code.
Thing is if a cell has only one value in it the macro stops seperating out any further multiple value rows (on the sample sheet)
on my sheet I have accounted for this by testing the boundaries of the split array, but another problem then is it seems to only do the first row then stops splitting them altogether, although it does step down through the rest of the rows
Ultimatly I want to be able to customize this so it works by selected column on a current work sheet, instead of the column being coded.
a sample of my spreadsheet is attached including the current code I am working with.
[RESOLVED] [Excel] split rows down macro
Reply With Quote