I am using Office 2007. Everything was fine in 2003. Now, I see this
problem--even when I follow your instructions. The visible cells only option
doesn't seem to work either.
--
Mauren


"Gord Dibben" wrote:

Autofilter results?

My Excel 2003 you just select the rows you see and copy/paste.

If you can't do that for dome reason, F5SpecialVisible cells onlyok.

Copy/paste.


Gord Dibben MS Excel MVP

On Mon, 12 Nov 2007 16:31:19 -0800, Maureno
wrote:

How do I set the filter so that I can copy only the filter results vs. the
filter results & the underlying data that was hidden.