ExcelBanter - Is it possible to tell if a cell is hidden by 'Autofilter'

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Is it possible to tell if a cell is hidden by 'Autofilter' (https://www.excelbanter.com/excel-programming/275808-re-possible-tell-if-cell-hidden-autofilter.html)

Dave Peterson[_3_]

Is it possible to tell if a cell is hidden by 'Autofilter'

how about:

msgbox cells(18,4).rowheight
or
msgbox cells(18,4).entirerow.rowheight

Look for when it's 0.

TonyJeffs wrote:

Suppose I use the autofilter command so that only rows 10 16 18 22 are visible,
Is it possible to establish whether a cell is visible using a macro?
Something like:
msgbox cells(18,4).visible

Thanks
Tony

--

Dave Peterson

All times are GMT +1. The time now is 10:45 PM.