Hi, FrankTimJr. I think you want to repost this on the Excel
Programming forum; this one is about worksheet functions. (But
yes, it's certainly possible to have a macro accept a range that's
already selected and sort that instead of use a different one.)

--- "FrankTimJr" wrote:
I'm curious to find out if I can eliminate the Range on the below
macro I created? I want to it to not care what Range I select, as
long as the Range includes cells from column AN (Not the entire
column). Since Excel 2007 does not save the sort parameters I
need to figure out a way to automate the sort. I have several
worksheets and several seperate ranges I need to sort on. Is
this possible? I want to run the macro AFTER I select the Range
I want to sort and not have the macro select the Range.