When I record a macro in Excel that includes sorting, the macro always hard-codes the cell range. So if I run the macro on another spreadsheet with more rows, it only sorts the top portion. Now, I know how to solve this with some VBA code, but I'm trying to demonstrate the value of recording macros to some people who do not know VBA... things like resizing columns, adding Autofilter, change formatting in columns, etc. The spreadsheets they would be working with would all have the same columns, but the number rows can change. Is there any way to record a macro that can be repeated, but will always sort all the rows without the addition of VBA code?