I'm struggling to work out what I'm doing wrong here: I want to copy columns A to L, and column O, from one worksheet to others. I'm using AutoFilter (in Excel 2003) to define what data goes to what worksheet, but it's always A:L and O to be copied.

However, the following code:

Sheets("Master").Select
    
    Range("A:O").AutoFilter Field:=3, Criteria1:="team name"
    Range("A:O").AutoFilter Field:=13, Criteria1:="No"
    Range("A:O").AutoFilter Field:=14, Criteria1:="="
        On Error Resume Next
        Range("A2:L" & LastLine, "O2:O" & LastLine).SpecialCells(xlCellTypeVisible).Copy
            Sheets("teamsheet").Range("A2").PasteSpecial
results in columns A to M only being copied. (The variable LastLine simply indicates the number of rows that have been filtered, so I don't think that will be related to the problem).

Can anyone advise why the macro is picking up column M rather than O please?