Hi i need a formula to

Select A1:K1 & Lastrow

    Dim Lastrow As Long
    Lastrow = Cells(Rows.Count, "A").End(xlUp).Row

    Selection.AutoFilter Field:=11, Criteria1:="=A", Operator:=xlOr, _
    Criteria2:="=BJ"
    
    Range("A1:K1" & Lastrow).Select
I have tried the above but it doesnt work it selects a1:k1 but then selects all the cells down to end of the excel document where as the data in cell a ends at row 500 (this can very depending on which sheets i am using).. any help .. ? my vb knowledge is basic but improving


would this work better ? Range("A1").CurrentRegion.Select