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

W

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

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

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top