I a worksheet with data in all cells of columns A-J, but columns C-H are
hidden. I need to copy ALL cells in columns A-J into another worksheet, not
just the visible ones. When AutoFilter is turned OFF, I can select a cell in
column A of the row I want to copy and CTRL+SHIFT+RIGHT to column J, then hit
CTRL+C (or click €˜Copy) and ALL data of the row (including hidden cells) is
copied, just like I want.

Now when I apply an AutoFilter, say to column I, and perform the same
procedure as above, it only copies the visible cells and omits the data in
columns C-H, its like the €œSelect Visible Cells€� button is always applied
with AutoFilter is on. How do I turn this off and select ALL the cells?
This is driving me crazy because its only happening with this particular
workbook.

Don't have/know xl2007, but this behaviour:
its like the €œSelect Visible Cells€� button is always applied with AutoFilter is on.
is the behaviour in xl2003/xl97, as far as I know

But why can't you simply remove autofilter, then do the copy n paste, if you
want ALL cells selected?
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---

But why can't you simply remove autofilter, then do the copy n paste, if you
want ALL cells selected?

I'm using AutoFilter to filter out rows of data that I don't want to copy,
however in the rows I do want to copy, I want all of the columns, even if
they are hidden.



"Max" wrote:

Don't have/know xl2007, but this behaviour:
its like the €œSelect Visible Cells€� button is always applied with AutoFilter is on.
is the behaviour in xl2003/xl97, as far as I know

But why can't you simply remove autofilter, then do the copy n paste, if you
want ALL cells selected?
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---

Fair comment. I missed that part about the hidden cols. I'm not sure if its
possible for the behaviour that you seek. Maybe other responders would drop
by with their views for you.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"west8100" wrote in message
...
But why can't you simply remove autofilter, then do the copy n paste, if
you
want ALL cells selected?

I'm using AutoFilter to filter out rows of data that I don't want to copy,
however in the rows I do want to copy, I want all of the columns, even if
they are hidden.