Excel 2007 :: Data Sort In Ascending Order

Excel 2007.

The first part of this code is fine and completes all the borders.
The second part is to the all the workbook by Data Sort in ascending order starting with

Column C
Then Q
Then column V

But also knowing to search to the last line. I think i might be close but not close enough for this to work.

Sub Macro2()
Dim LR As Long, i As Integer
Dim mysheet As Worksheet

Sheets("Test").Select
LR = Range("A" & Rows.Count).End(xlUp).Row
With Range("A9:AD" & LR)

[Code] .......