Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
COPY - *want* to include hidden columns
I need to copy a row from one worksheet to another, and am using this
statement to do so: Application.Range(sCurrentTaskAddress).Copy Destination:=Application.Range(sNextUpdateRowAddre ss) where sCurrentTaskAddress represents the address of an entire row in the source wks. I could swear it was working as I'd expect it to, copying ALL the cells in the row whether some columns were hidden or not, but it's only copying visible cells. I thought you need to do Special(xlVisible) or something like that to get that behavior. Any help to let me copy everything, hidden or not, much appreciated as I need to get this done. Thanks, Eric |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy/Paste with Hidden Rows/Columns Excel 2007 | Excel Discussion (Misc queries) | |||
Copy and Paste with hidden columns remaining hidden | Excel Discussion (Misc queries) | |||
Not include hidden columns in copy paste | Excel Discussion (Misc queries) | |||
How do I copy a worksheet so that hidden columns remain secret? | Excel Discussion (Misc queries) | |||
how do i copy formula down columns avoiding hidden cells | Excel Discussion (Misc queries) |