change the a4000 to b4000, c4000 or whatever the last column you want to include
in the sort.

--


Gary


"N. McCain" wrote in message
...
Also I need it to start sorting at row 3

"N. McCain" wrote:

Private Sub CommandButton1_Click()
Range("a3").Activate
Range("a3:a4000").sort Key1:=Range("a3")
CommandButton1.Activate
End Sub

I need to be able to sort 4000 rows and columns A-L.

"Jim Thomlinson" wrote:

Post your code... How many columns are there to sort...
--
HTH...

Jim Thomlinson


"N. McCain" wrote:

I need a command button to sort the entire sheet by column "A" in
ascending
order. My button is only sorting column "A" and nothing else. Can
someone
please help me? Thanks in advance