View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default How to find each cell with non-negative value?

From help on autofilter.

"When you use the AutoFilter command, AutoFilter arrows appear to the right of
the column labels in the filtered range."


Note "column labels" means titles in row 1

A bit ambiguous and does not specifically state that autofilter results will not
include the cell with the arrow.


Gord Dibben MS Excel MVP

On 14 May 2007 16:36:02 -0700, "
wrote:

Does AutoFilter expect (require) that the first row is a title row?

I do not see where that is stated explicitly in the Help page. But
the example does show a title row.