VB script to sort rows by lots of columns

[Tom Doster]

Does anyone have a VB script that will let me sort a series of rows by as
many columns as I like? The capability in Microsoft Excel 2002 is only
three. I need the capability to sort by at least eight columns.

Thanks,
Tom Doster

 

[Dave Peterson]

Record a macro when you do the sort 3 times.

Start with the least important 2, then middle 3, then most important 3.

Then when you need to sort again, just playback that macro.

 

[SidBord]

Funny you should ask . . . I was just doing that today.
The easiest thing to do (in Excel 2003) is start the
"Record A Macro" facility, then select the array you want
to sort, then start the Sort feature. Then turn off the
macro auto record. It'll show you how to do it. I think I
was sorting 11 columns.