lists and arrays in VBA
You will have to change some of your data types but the basics of what you just posted could be converted to something similar to this given the data types I used may not be accurate. Collections cannot be sorted so if you need to sort data you will probably want to use an array. … Read more