Saving Sorts

  • Thread starter Thread starter Ron
  • Start date Start date
R

Ron

I rarely use Excel, so this may be a very elementary
question, but...

On one of my worksheets, I cannot get a Sort to save --
that is, when I select sort, there is no previously used
sort as the default. The sort itself works fine (once I
manually go through setting it up). Also, on every other
worksheet, this works fine.
 
Ron,
Normally, the kind of "automatic" memory Excel and other offic
products exhibit in their interfaces are dependent on saving the fil
when we exit. So, if this is a file you open, take a look at, after yo
sort that is, but then close the file and decline to save the file whe
asked, you lose that cool "auto" stuff. Now, I'm not a programmer jus
a very frequent user of Excel and I too rely on the program rememberin
my last sort preferences and I can't recall having your problem. But
always save as I close the file. So that might be the problem.
Case
 
Hi Ron.............

I suggest you look into recording your own macro to do the sort for you if
you do the same one all the time...........just do Tools > Macro > Record
new macro.........and then follow the menu and perform the steps as normal
and then hit Tools > Macro > Stop recording.............then you have it.
Give it a try, and if you run into trouble, just come back here and someone
will help.

hth
Vaya con Dios,
Chuck, CABGx3
 
Back
Top