| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select hidden cells
I know you can select visible cells with:
Range.SpecialCells(Excel.XlCellType.xlCellTypeVisi ble).Select Is there a way to select the opposite of that? Just selecting the hidden cells. Thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select hidden cells
you can't select a cell if it is hidden...
what are you trying to do? -- Allllen "ALV" wrote: I know you can select visible cells with: Range.SpecialCells(Excel.XlCellType.xlCellTypeVisi ble).Select Is there a way to select the opposite of that? Just selecting the hidden cells. Thanks. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select hidden cells
Thanks Allllen.
I want to copy a ListObject to an array (C#) where all hidden cells values are set to null. I can do it by looping over all rows, but its extremely slow. I'm hoping I can copy the range, set hidden rows to null and use get_Value to put it in an array quickly. "Allllen" wrote: you can't select a cell if it is hidden... what are you trying to do? -- Allllen "ALV" wrote: I know you can select visible cells with: Range.SpecialCells(Excel.XlCellType.xlCellTypeVisi ble).Select Is there a way to select the opposite of that? Just selecting the hidden cells. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Up down arrow keys do not select cells if select locked cells unch | Excel Discussion (Misc queries) | |||
| drag data vertically over hidden cells.. ignore hidden cells | Excel Discussion (Misc queries) | |||
| How do I paste hidden cells and keep them hidden? | Excel Discussion (Misc queries) | |||
| How to select all hidden text boxes | Excel Discussion (Misc queries) | |||
Linear Mode
