I am trying to tidy my code and hopefully make things a bit more efficient and faster. I have the (mostly) macro generated sort routine below which works fine but just looks very bloated and inefficient.
What I have distilled it to is that below but it fails at Key4 and I am assuming this is a throw back to pre Excel 2007 restrictions. What I need to understand is the best practice and minimum requirements for building a sort routine so I can get it straight in my head.Please Login or Register to view this content.
Thanks for any advice, all is welcome so I can finally understand what IS and what IS NOT necessary in a sort routine.Please Login or Register to view this content.
Bookmarks