how do I select, cut, and paste visible cells only

Giganews Newsgroups
Subject: how do I select, cut, and paste visible cells only
Posted by:  Cutting and pasting invisible cells
Date: Wed, 10 May 2006

When I use filters to leave only certain cells visible, cut them and paste
them to a new column, when I open up the hidden cells, both visible and
invisible cells are pasted to the new column and not just the invisible cells
selected, cut, and pasted.  This is a large workbook.  A macro to do this
would be great for future use.  I am a computer idiot.

Replies