Sort data with command button

[MarkV]

How can I create a command button on an excel worksheet
that will sort the worksheet by data in one column? Since
the data will be increasing (more rows will be added) how
can I specifiy the range to include all rows?

Thanks
MarkV

 

[Bob Phillips]

There is already a button, The AZ and down/up arrows. Select the column and
press this button.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[MarkV]

Yes that will work manually.

I don't want operators to select the range, because I am
afraid they will miss a column and the data will be out of
sync. I want the operator to press a button, which will
sort all rows by (say) column 1 values. How is this done
in vba code?

Mark

 

[Bob Phillips]

ActiveSheet.UsedRange.Sort key1:=Range("A1"), header:=xlGuess

although it may need refinement, for instance for headers.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)