It worked ok for me, see attached file (and yes, it is 02:30!).

File won't upload so here's a link

snb has a great site http://www.snb-vba.eu/VBA_Arrays_en.html