Button/Link on worksheet to Sort

**Patchworks** · 07-12-2009, 07:35 PM

I would like to have a button or a link on my spreadsheet that when it is clicked will sort my table with a pre-defined sort.

Is there a way to do this?

g

**Palmetto** · 07-12-2009, 09:12 PM

Yes. Record a macro going through all of the steps of applying the sorting.

Next, create a button object from the Forms controls and assign the macro to this button.

The resulting VBA code won't be the most efficient, but you can post it and someone will help refine it for you.

Suggestion: create a dynamic named range to be used as the sort range so that as data is added or deleted your range reference in the VBA will always be current. The dynamic named range will have to be hand coded into the macro.