And if you do it often, you may wish to add that particular icon to your
toolbar, to make it a little easier.

Right click in the toolbar and choose "Customize".
Click on the "Commands" tab,
and in the left window click on "Edit".

In the right window, scroll down almost to the bottom and click on the
"SelectVisibleCells" icon, and drag it to your toolbar.

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Rodney" wrote in message
...
AAaaaaaaaah, so that's where it was hiding.
My help file offered no hints.

May your stockings overflow at christmas with gifts that delight.


| Before copying, use Edit / Go To.... Special, Visible cells only.
|
| HTH,
| Bernie
| MS Excel MVP