copy data when Autofilter On and active

S

sebastien

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top