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.
Hope this turns out to be useful to some other newby.
Please Login or Register to view this content.