VBA to sort 6 columns only

[Trueblue862]

Hi, I have a spreadsheet that has 6 columns of data in the middle of it I want to sort, C through H, starting at row 3. Is there a way of sorting these with VBA without touching the information to the sides of the sheet? I hope this is clear enough. Any help would be greatly appreciated.

 

[Osvaldo Palmeiro]

Hi. Please, see if this code could help you.

Sub SortColumnsCH()
 Range("C3:H" & Cells(Rows.Count, 3).End(3).Row).Sort Key1:=[C3], Order1:=xlAscending, Header:=xlNo, DataOption1:=xlSortTextAsNumbers
End Sub

 

[Trueblue862]

Thank you, I’ll give it a try as soon as I get back to my computer.

 

[Trueblue862]

Hi, sorry for the late reply. I'm getting a run-time error '1004', sort method of range class failed.