M
mofojed
When using autofilters, if you have a topic automatically filtered and you
select a range of cells and copy them, traditionally it works okay. It does
copy the correct cells originally (ie. The cells that are not hidden by the
autofilters), and pastes into another sheet correctly. However, if you paste
the cells, and then undo the paste, then repaste the cells, it will paste all
of the cells that were hidden by the autofilters as well.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...fe6eaa3&dg=microsoft.public.excel.crashesgpfs
select a range of cells and copy them, traditionally it works okay. It does
copy the correct cells originally (ie. The cells that are not hidden by the
autofilters), and pastes into another sheet correctly. However, if you paste
the cells, and then undo the paste, then repaste the cells, it will paste all
of the cells that were hidden by the autofilters as well.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...fe6eaa3&dg=microsoft.public.excel.crashesgpfs