If you do this often, you can place an icon on your toolbar.

Right click in the toolbar and choose "Customize", then "Commands" tab.

In the left window click on "Edit",
Scroll almost to the bottom of the right window, and click on "Select
Visible Cells"
Drag it to your toolbar.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"paulajo" wrote in message
...
i've fitered to unique records only - how do I paste visable cells only?