Reorder Rows (Manual Sort), Copy, Insert, Delete Row

I am reletively new to VBA and a lot of web trawling was not yielding the answer to this simple question so hopefully this will help someone else.

I was faced with having to reorder rows within subsets in a worksheet which could not be defined in a normal sort and had to be done through loops and If Then statements. I turns out this was not as difficult as I first thought and the code below shows it in simple fashion.

Please Login or Register  to view this content.

Hope this turns out to be useful to some other newby.