Pasting Visible Cells

I have a filtered list and I want to copy and paste only the visible cells to
a new worksheet. Help Please!!!???

If you're using xl97+, then just selecting those visible rows and copy|pasting
should be sufficient.

If you're using xl95, then you have to select the range first,
then edit|goto|special|visible cells only

Then copy|paste.



LyndieBee wrote:
>
> I have a filtered list and I want to copy and paste only the visible cells to
> a new worksheet. Help Please!!!???

--

Dave Peterson