Pasting into visible cells only

Giganews Newsgroups
Subject: Pasting into visible cells only
Posted by:  TV Man (sca…
Date: Thu, 9 Oct 2003

I have two worksheets that are set up to custom view with
a sort function; i.e. it hides lines. I know how to copy
visible lines to a fully open worksheet. If the worksheet
I want to copy to is also sorted to have the same number
of visible lines is there a way to copy just into those
visible lines? I get an error box saying " cannot paste in
to multiple selections".