ExcelBanter - copy only filtered range.

I saw this response in another forum:

The key here is that if you select just the table (or cells in the same rows
as the table) to copy, then you will get the filtered data.

If you select the filtered cells, plus data outside the table (the row
above/below/both) then you will get the entire list (unfiltered).

You can tell what you are going to get by looking at the "running ants"
selection after pressing Ctrl+C. If you see only one area with the running
ants around the outer perimeter, you are going to get the whole table. If
you see several 'mini-selections' inside a larger bold border, then you will
get the filtered data.

Miri wrote:

hi,
i'm using filters in 2007, then i select range inorder to copy only the
filtered.
but actually it copy the full list.
in other computer, with 2003 it works. maybe it is a configrable problem.
any idea?
thanks,
--
Miri Tz.

--

Dave Peterson