Compile Error on Sorting

[Pat_The_Bat]

I'm trying to insert a line of code at the end of my macro that will sort the list alphabetically. I keep getting this compile error and it points to the word Key1 in my line of code saying that it expects the end of a statement

 With Sheets("Doc Checklist").Range("C2:C500").Sort Key1:=Range("C2") Order1:=xlAscending, Header:=xlNo

also, should the Range right after Key1 have a Dot before it. I've written both ways thinking that might be giving me the error, but it's not what is causing it.

Thanks in advance

 

[Fluff]

Remove the word With from the start of that line

 

[Marcelo Branco]

Or

With Sheets("Doc Checklist")
    [B][COLOR=#ff0000].[/COLOR][/B]Range("C2:C500").Sort Key1:=[B][COLOR=#ff0000].[/COLOR][/B]Range("C2"), Order1:=xlAscending, Header:=xlNo
End With

M.

 

[Pat_The_Bat]

Or

With Sheets("Doc Checklist")
    [B][COLOR=#ff0000].[/COLOR][/B]Range("C2:C500").Sort Key1:=[B][COLOR=#ff0000].[/COLOR][/B]Range("C2"), Order1:=xlAscending, Header:=xlNo
End With

M.

Thanks Friends! Very helpful!