Just use the top cell of the column as the Key1 and Key2 criteria:

Key1:= Range("A1"), Key2:= Range("B1")

Or am I misunderstanding you?

--

Vasant




"Kevin Sprinkel" wrote in message
...
I'd like a general sort macro that will sort the selected
rows in our Schedule spreadsheet, always by the same two
columns, with no header rows.

After creating a recorded one, the code specifies the top
cell in each column in the Key# criteria. This will in
general, be different each time.

TIA
Kevin Sprinkel