this works on Excel XP.

I'm finding XL-VBA a bit tougher than Access VBA... but a new
challenge is fun.

Note that to declare an Array with a variable as the size you need to
use 'ReDim', instead of 'Dim' (new to me as well).