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?
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?