If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook, you can
nest the ArrayRowFilter functions:

=ArrayRowFilter2(ArrayRowFilter1(ArrayRowFilter1(A rrayRowFilter1(ArrayRowFilter1(ArrayRowFilter1(dat arange,1stCol,1stCrit),2ndCol,2ndCrit),3rdCol,3rdC rit),4thCol,4thCrit),5thCol,5thCrit),6thCol,6thCri t)
array entered into a range sufficiently large to accommodate the final
output. Note that the first function is ArrayRowFilter2, the remainder
are ArrayRowFilter1. This is to avoid getting an error message if the
selected range is large enough for the final output but not large enough
for an intermediate output. If the selected range is not large enough
for the final output, the error message will indicate the range size to
be selected.

Alan Beban

TBA wrote:
Excel 97
Windows 2k Pro

I know that using Excel's built in Sort menu option that I can only sort up
to three columns at a time. I went ahead and recorded a sort as a macro to
get the basic code for doing this in VBA, so I was wondering if I can add a
4th, 5th or 6th sort key in the VBA code for the Macro. I've tried doing
this by mimicking the code but adding a 4th key, using the same syntax as
the macro code, but I got an "unknown object" error. Is it just not meant
to be?

-gk-