B
BillCPA
Is there any VBA function that can be called to sort an array?
F
Frank Kabel
Hi
there's no build-in function. One workaround:
- place your data in a worksheet range
- sort the range usings Excel' sort features
- read the data into your array
there's no build-in function. One workaround:
- place your data in a worksheet range
- sort the range usings Excel' sort features
- read the data into your array
D
Don Guillett
you might find help here.
http://tinyurl.com/6mge2
http://tinyurl.com/6mge2
B
BillCPA
The code at tinyurl looks good, but it is all from 1998. Have there not been
any code improvements to VBA since 1998 that might improve performance?
any code improvements to VBA since 1998 that might improve performance?
F
Frank Kabel
Hi
not really
The code should work without any issues in the newer Excel versions
not really
The code should work without any issues in the newer Excel versions
M
Myrna Larson
There have been functions added to VBA since 1998 (Join, Split, Replace come
to mind), but sorting isn't one of them.
to mind), but sorting isn't one of them.