Hi and thanks in advance,

I'm using Excel 2003 and in VBA trying to merge 2 named ranges that each have the same 3 columns, sort by 1 of the columns and then add the merged/sorted range to a 3 column listbox.

The 2 named ranges are on the same sheet and are as follows:

rng1 is A1:C20

rng2 is A30:C50

Column A & B are text and C is date

In VBA I want to combine these 2 ranges into 1 range object of 3 columns, sort by column C (date) and then load into a three column listbox.

The alternative might be to sort the listbox I suppose.

Not sure how to do any of this?