Sort columns A:C but leave others

[sharky12345]

How can I sort columns A:C using VBA but leave the others columns untouched?

Column A needs to be sorted from A2 down and in ascending order.

 

[Joe4]

Turn on the Macro Recorder, and record yourself doing this manually, and you should get the VBA code that you require.

 

[sharky12345]

I've tried that, but it sorts the whole sheet and sends the data in the other columns all out of sync.

 

[Jetx227]

I've tried that, but it sorts the whole sheet and sends the data in the other columns all out of sync.

Try something like this

Sub Sort_Col()

Worksheets("Sheet1").Columns("A:C").Sort key1:=Range("A2"), order1:=xlAscending


End Sub