Sort a worksheet

[Computerman]

I have a worksheet with columns A through R. I need to sort this worksheet by the value that is in Column C. I have searched for the answer and have tried several suggestions, but the worksheet never sorts. In my code below I have commented out all the things I have tried. Is what I am trying to do possible, and if so, how?

Private Sub cmdBuildOrders_Click()
cmdBuildOrders.Caption = "Running"
cmdBuildOrders.BackColor = RGB(255, 255, 0)
cmdBuildOrders.ForeColor = RGB(0, 0, 0)
Application.Wait (Now + TimeValue("0:00:01")) 'allows command button to change text and back color

lastrow = Sheet3.Range("A100").End(xlUp).Row

Sheet3.Activate
'Range("C1:C17", Range("C1").End(xlDown)).Sort Key1:=Range("C2"), Order1:=xlAscending, Header:=xlYes

'ActiveSheet.Sort.SortFields.Clear
'Columns("A:R").Sort Key1:=Range("C2:C17"), Order1:=xlAscending, Header:=xlYes

'Range("A2:R17").Sort Key1:=Range("C2"), Order1:=xlAscending, Header:=xlYes

'Range("C2").CurrentRegion.Sort Key1:=Range("C2"), Order1:=xlAscending, Header:=xlYes

'LastRowSort = Sheet3.Cells(Rows.Count, 2).End(xlUp).Row
'Range("A2:R" & LastRowSort).Sort key1:=Range("C2:C" & LastRowSort), _
   order1:=xlAscending, Header:=xlNo


'For Row = 2 To LastRow
'    Sheet4.Cells(Row, 2).Value = "MPS"                             'Customer Code Parent Row
'    Sheet4.Cells(Row, 3).Value = "ATNA"                           'Project Code Parent Row
'    Sheet4.Cells(Row, 5).Value = "Standard"                     'Type Parent Row
'    Sheet4.Cells(Row, 6).Value = "Pick Pack and Ship"    'Attribute Parent Row
'    Sheet4.Cells(Row, 13).Value = "False"                         'IsAccessory Child Row
'    Sheet4.Cells(Row, 14).Value = "False"                         'IsConfiguration Child Row
'    Sheet4.Cells(Row, 15).Value = "False"                         'Reservation Parent Row
'
'Next Row
cmdBuildOrders.Caption = "Build Customer Page"
cmdBuildOrders.BackColor = RGB(0, 176, 80)
cmdBuildOrders.ForeColor = RGB(255, 255, 255)
End Sub

Computerman

 

[Fluff]

Glad we could help & thanks for the feedback