quick sort macro

I find it very frustrating that the excel sort feature doesn't remember the last sort criteria, or have some sort of history list. It takes forever to have to re-enter sort criteria over and over when you need to repeat an operation.

Can someone let me know how to write a macro that will sort whatever range of rows is currently selected. The column(s) to sort on and sort order will be the same every time and so can be hard coded in the macro. The range needs to be picked up from what ever is selected on the active sheet.

Thanks,

LMHmedchem

LM,

Try using the macro recorder.

Lewis

I did use the macro recorder and this is what I end up with.

Please Login or Register  to view this content.

The recorder produces a script that will sort rows 254:262 in worksheet Sheet1. I need this to be more generic and sort whatever rows I have selected at the time when I run the macro. Ideally, I would just like to select some rows and keystroke the shortcut. I don't know VB anywhere near well enough to make those changes.

LMHmedchem

Originally Posted by shg

Please Login or Register  to view this content.

I'm not sure how you specify the column letter name to sort on. There will not be a header row in the selection, so it would need to be a column letter.

LMHmedchem

for some reason, my last reply didn't appear on the main board and it still looks like shg posted the last message.

Originally Posted by shg

Did you try it, or are you speculating?

It sorts on the first column of the data.

Yes, it does sort on the first column with the ctrl+h keystroke (which I added), but most of the time I need to sort on a column other than the first. In this case I need to sort on the 6th column, small to large, but it would be nice if the script were generic so that I could edit it for different sort criteria.

I didn't see anything obvious for where I could indicate the column to sort on.

LMHmedchedm

Originally Posted by shg

Please Login or Register  to view this content.

I thought that I tried that and got an error, maybe I changed the value of Key1 to Key6 instead.

Thanks, that works just fine. What would the syntax be if I wanted to sort on more than one column, like 4 then 6?

LMHmedchem