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.

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.

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.