Thread: Is it possible to tell if a cell is hidden by 'Autofilter'
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
  
Posts: 2,824
Default 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

Reply With QuoteReply With Quote