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:

Please Login or Register  to view this content.
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?