PC Review


Reply
Thread Tools Rate Thread

copy data when Autofilter On and active

 
 
sebastien
Guest
Posts: n/a
 
      19th Dec 2008
Hi, (XL 2003)
Strange behavior when autofilter is On and has some filters applied:

Say I have a table of data starting in Row 5
Say row 2 (above the table) is hidden

1. With no filters applied (whether or not the AutoFilter is On)
ActiveSheet.Cells.Copy NewSheet.Cells
--> all cells are copied

2. Now I apply a filter on the table
ActiveSheet.Cells.Copy NewSheet.Cells
a. --> it only copies the filtered rows in the table, however Row 2 which is
not part of the table is not copied either while it was in the previous case.
The 'issue' seems to be coming from the Copy: went you copy manually ,
you already see the highlight around row 2 indecating it is not part of the
copied cells.
b. --> Finally, even if you try to copy the top rows and table rows
separately, Row 2 is still not copied over.

What I wwant is to be able to copy:
- only the visible rows from the table
- and any row outside the table (even though those rows are hidden).
when a filter is applied.

Any idea?

Thanks

Sebastien
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
autofilter master copy data to worksheet Hobbes Microsoft Excel Programming 1 22nd May 2010 01:15 PM
Autofilter on non-active sheet =?Utf-8?B?dGlnZ2Vy?= Microsoft Excel Programming 5 5th Nov 2007 11:22 AM
Copy data from 3rd worksheets and pasting to active worksheet KimberlyC Microsoft Excel Programming 4 29th Jun 2005 02:09 AM
autofilter on a not-active sheet Peter Microsoft Excel Programming 2 15th Jan 2005 12:33 PM
Macro to copy cell data to word document based on an active row? =?Utf-8?B?QnJpYW4=?= Microsoft Excel Programming 2 16th Sep 2004 01:55 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:04 AM.