I am aware that I should write a macro in personal.xls but for the next
version of excel please put the function: "edit - go to - special - visible
cells only" somewhere more accessible.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

Hi,

You could right-click a toolbar, select Customize..., select the Commands
tab, select the Edit category, scroll down to the end of the commands list.
Third from the bottom is a button to select visible cells only.
Click-and-drag that to a toolbar.

No macros required - just customizing your toolbar.

Ed Ferrero
http://edferrero.m6.net

"The Walm" wrote in message
...
I am aware that I should write a macro in personal.xls but for the next
version of excel please put the function: "edit - go to - special -
visible
cells only" somewhere more accessible.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

You can customize your favorite toolbar with an icon that does that for you.

Tools|Customize|Commands tab|Edit category
Look for select visible cells
and drag to your favorite toolbar.

Select your bigger range and then click that button!

The Walm wrote:

I am aware that I should write a macro in personal.xls but for the next
version of excel please put the function: "edit - go to - special - visible
cells only" somewhere more accessible.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

--

Dave Peterson

Ah - I forgot about this - thanks Dave and Ed - this makes it much quicker.

"Dave Peterson" wrote:

You can customize your favorite toolbar with an icon that does that for you.

Tools|Customize|Commands tab|Edit category
Look for select visible cells
and drag to your favorite toolbar.

Select your bigger range and then click that button!

The Walm wrote:

I am aware that I should write a macro in personal.xls but for the next
version of excel please put the function: "edit - go to - special - visible
cells only" somewhere more accessible.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

--

Dave Peterson