Equivalent vba code to manual table sort

sumdumgai

Registered User.
Local time
Today, 09:21
Joined
Jul 19, 2007
Messages
453
Can someone please give me the equivalent VBA code to opening a table, placing the cursor on the down arrow in the field header, and sorting A-Z? I know sorting tables isn't the right thing to do (use queries instead), but I'd like to know the code. I've located code to create the query to sort the table, but the table itself isn't sorted; i.e., its design hasn't changed.

Thanks.
 
You wrote "I know sorting tables isn't the right thing to do"

So you are asking for help to promote bad practice.

Not me.
 
you don't sort table, leave it as raw.
use query to do the sorting.
 

Users who are viewing this thread

Back
Top Bottom