Macro to sort a predefined list

G

Guest

I need to make a button on my excel sheet that will sort a pre-defined area
(A2:K103) on my sheet the same way as selecting the area manually and then
selecting sort. Can this be done and how?
 
P

Peo Sjoblom

Record a macro while doing this, then attach it to a button from the forms
toolbar

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
R

Rsummers

I made the macro button that selects the range of data i want, but i want
the person that is pressing the button to be able to choose how it is sorted
without that person to have to choose the sort feature in the above toolbar,
how can this be done in one macro?
 
Top