In Excel 2003 I copy a range of columns from a filtered datain one workbook
and paste into another in a number of macros.
In 2007 I get the "can't paste because paste and copy area are not the same
shape" error message. I can find no way round this. If I manually copy a
whole column which has autofilter on (and is filtered in some way), I cannot
paste that column into another sheet.

There must be a work-a-round - please can you help?