LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Copy Paste filtered column ok in 2003 not in 2007

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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
copy and paste filtered cells Rich Excel Discussion (Misc queries) 1 February 27th 08 01:50 AM
Excel 2007/2003 compatibility problem - copy and paste [email protected] Excel Discussion (Misc queries) 0 December 6th 07 02:57 PM
Copy and Paste Filtered Cells in Excel 2007 Gillian Excel Discussion (Misc queries) 0 December 5th 07 03:46 PM
copy and paste filtered data Churley Excel Discussion (Misc queries) 6 September 4th 07 04:17 PM
Dificulty in copy and paste when items is filtered in excel 2007 henksa Excel Worksheet Functions 2 August 21st 07 07:34 PM


All times are GMT +1. The time now is 01:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"