Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy ListObject with non-visibles NULL
I'm trying to figure out a way to get a copy of a table where any
filtered or hidden cells in the source end up NULL in the copy. Is there a simple way to do that? My best guess so far is: 1) Copy the range to a temp sheet and make it a table 2) Copy the filter (if that can be done) 3) In the copy, invert the filter (if that can be done) or set a property on all Visible cells and then select cells that don't have that property 4) Set selected cells to NULL If anyone has an easier way or knows how to copy a table in a way that keeps all hidden/filtered cells invisible in the copy, please let me know. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Failed to save table attributes of (null) into (null). | Excel Discussion (Misc queries) | |||
Don't Copy If Null -- Help | Excel Programming | |||
Copy contents of Cell to array based on Col1 value not null | Excel Programming | |||
copy cell with non null value | Excel Programming | |||
PASTE INTO JUST VISIBLES CELLS | Excel Programming |