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

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.