Macro to sort a predefined list

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?

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)


wrote in message
m...
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?

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?
"Peo Sjoblom" wrote in message
...
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)


wrote in message
m...
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?