View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default Store sorting argument in Excel

Hi,
One way: Turn on the macro recorder, then do your sort manually, as usual.
Turn off the macro recorder. Now every time you run that macro, it will sort
as you specify. You can record several macros, each sorting by different
criteria - ie sort by date, sort by value, sort by name, etc.
Is this what you mean?
Regards - Dave.