Identify Hidden but not filtered cells

**anshul03** · 05-03-2012, 02:17 AM

I am trying to extract all the visible worksheets in a few workbooks into double pipe delimited text files. For this I want to take into consideration only the cells that are 'not hidden' on a worksheet.

As per my understanding a cell can be hidden when:
- either its row / column has been manually hidden by user
- or its row has been filtered out due to autofilter applied on header or either of the columns

I want to exclude the manually hidden rows / columns but want to take into consideration the rows that have got hidden due to the applied autofilter.

Can someone suggest me on how to identify cells of this kind. I am currently using the following code, but this leaves out the cells hidden by autofilter as well.

Please Login or Register  to view this content.

Any prompt help on this shall be highly appreciated!!

**tkowal** · 05-03-2012, 12:27 PM

I believe Excel does not make a difference between a Hidden/Filtered cells/row both are "Hidden"; However you may be able to test the intersection of EntireColumn being Hidden and the row.

This one is definitely for the GURU's

**royUK** · 05-03-2012, 01:10 PM

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

**anshul03** · 05-05-2012, 03:47 PM

Thanks royUK for the suggestion. While posting the thread I actually was looking for ways to keep the formatting of code intact but was not able to figure it out. Your guidance definitely helped on that.