I have the following code behind a combobox:

Private Sub ClientList_Change()
' this sorts the names alphabetically

Worksheets("Home").Range("C8:C27").Sort _
Key1:=Worksheets("Home").Range("C8"), _
Order1:=xlAscending

End Sub

I am trying to list the contents of c8:c27 alphabetically
in the combobox. This code does that but as soon as I
choose from the combobox I get the following error:

Run-time error '1004':
Sort method of range class failed

I have data in all of the cells that the code is sorting.
I would appericate any help with this matter. Thanks.