Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

I have not been able to find a method to sort a VBA array. Does this mean that I have to copy the values to a worksheet and then use the Range.Sort method?

April 26, 2017able array copy mean method sort values VBA worksheet

0

Posted

I have not been able to find a method to sort a VBA array. Does this mean that I have to copy the values to a worksheet and then use the Range.Sort method?

1 Answer

0

Posted

There is no built-in way to sort an array in VBA. Copying the array to a worksheet is one method, but you’ll probably be better off if you write your own sorting routine. There are many sorting algorithms available, and some are quite easy to code in VBA. Excel 2000 Power Programming With VBA contains VBA code for several sorting techniques.