HELP: Selecting Non-Visible (Hidden) Cells with AutoFilter Applied

[west8100]

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, it’s 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 it’s only happening with this particular
workbook.

 

[Max]

Don't have/know xl2007, but this behaviour:

it’s 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
---

 

[west8100]

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]

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
---