Auto sort routine
Posted on 2011-09-28
I have a macro that looks for changes in a column of numbers. When a number is added to the last column, it automatically "fits" the number into the proper sequence (Low to High).
Now if I add 3.2 in the last cell, it will reorder the column as;
The problem is, if I add 3.2.1, it will put it at the end of the column instead of after 3.2; apparently not recognizing the expanded requirement for another sub.
Any ideas on how to fix the recognition of the number or position based on this schema?