active column headers for sorting

[thetrystero]

hello all,

i'm new to excel programming, so i'm not sure if there is just a simple macro that'll do this or if i need vba, so bear with me.

i have a table of values, with headers along the top and what i'd like to be able to do is to sort the entire table (all rows) according to which column header i click on, just like sorting by date, filename etc. in Explorer (on Windows) or in the Finder (on OS X).

this seems like pretty standard fare, but my searches both in the forum and on google have not revealed anything.

any help would be greatly appreciated!

[royUK]

This is the basic code that you can adapt. It uses the double click event, so double clicking on a header cell will sort the table.

Please Login or Register  to view this content.

To add the code right click on the sheet's tab and choose View Code. This will open the VB Editor. In the left hand drop down select WorkSheet and in the right hand one find BeforeDoubleClick. Then copy & paste the code.

You will need to amend the row & column references.