VB script to sort rows by lots of columns

T

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
 
D

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.
 
S

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.
 
Top