sort – Useful code

Sort a range in VBA with System.Collections.ArrayList Numerically

By Vitosh Posted on April 10, 2018 Posted in VBA \ Excel Tagged with Numerically, sort, System.Collections.ArrayList

Imagine you have a task to sort the range from column A based on the number after the last digit. A quick decision is to use Column “B” as a helping column where you write the cell, splitted by the …

Sort a range in VBA with System.Collections.ArrayList Numerically Read more »

VBA – ArrayList class – a helper to sort arrays in VBA

By Vitosh Posted on February 12, 2018 Posted in VBA \ Excel Tagged with arraylist, Excel, sort, sort array, VBA

If you are coding professionally in VBA, most probably you are using arrays every now and then and you have your own function for sorting an array. Something like this bubble sort or anything similar is what you have written …

VBA – ArrayList class – a helper to sort arrays in VBA Read more »

Tag: sort

Sort a range in VBA with System.Collections.ArrayList Numerically

VBA – ArrayList class – a helper to sort arrays in VBA