Get Array of Hidden Rows and Columns indices

[tttmack]

Is there a way to get an array of all the indices of the hidden rows and columns within a worksheet?

I would like to do this without any looping, perhaps using Range.Find() if its possible or whatever is most efficient. Ideally I would like to have two functions (FindHiddenRows and FindHiddenCols) each that return an array of integers.


Efficiency is very important to me, as I would like to be able to translate this code from VBA to VSTO (C#). VSTO is very slow at repeatably interacting with the Excel object model, so looping is not a solution that would work for me.


Thanks for your help!

 

[sheetspread]

specialcells will give you the visible ones without a loop, you can then use that to get the hidden ones

 

[tttmack]

thanks so much!

exactly what i was looking for and should be very efficient