Thread: select column A and B but not row 1

sorry for this stupid question...

i am trying to select column A and column B and apply a filter. however, I don't want the filter to be applied to row 1...

so i tried adding

Code:

Selection.Offset(1, 0)

somewhere in the following code but i couldn't get it to work...

Code:

Sub Macro8()
'
' Macro8 Macro
'

'
    Columns("A:B").Select
    ActiveWorkbook.Worksheets("sort").Sort.SortFields.Clear
    ActiveWorkbook.Worksheets("sort").Sort.SortFields.Add Key:=Range("A1:A351"), _
        SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
    With ActiveWorkbook.Worksheets("sort").Sort
        .SetRange Range("A1:B351")
        .Header = xlGuess
        .MatchCase = False
        .Orientation = xlTopToBottom
        .SortMethod = xlPinYin
        .Apply
    End With
End Sub

please share your insights

I don't see any filter code, I see sort code. Forget the macro for a moment and just tell us what you want to do... Sort columns A and B by column A values and leave the header at the top?

Something like this then?

Code:

Sub Sort()
Dim LR As Long

Worksheets("sort").Activate
LR = Range("A" & Rows.Count).End(xlUp).Row

Range("A2:B" & LR).Sort Key1:=Range("A2"), Order1:=xlAscending, Header:=xlNo

End Sub