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
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