I currently have this macro in a spreadsheet to expand rows into singles:
Please Login or Register  to view this content.
Now it works fine, but the problem is that with the data being input (around 24000 right now) it takes a few minutes to complete the task. The PC's here aren't the best, but I was simply wondering if there is a way to make the code more efficient (for sake of any points, the end has to be variable, the start is always at 11, there are other things going on in the spreadsheet that don't come into play till later).

I got this code off one of these types of forums (or was it guide? I checked many :s) originally, and while I have coded in the past I am by no means proficient. I first attempted to use formula to get around the issue of multiples but sums and counts didn't like to work, neither did the inbuilt subtotal feature.

Is there a faster way? Did I miss a much simpler method in splitting values into single rows like this code does?