View Single Post
  #3   Report Post  
Earl Kiosterud
 
Posts: n/a
Default

Dennis

ActiveSheet.AutoFilter.Range.Row gives you the number of the heading row,
which contains the dropdowns.

The following will select the first one.
Roww = ActiveSheet.AutoFilter.Range.Row
Coll = ActiveSheet.AutoFilter.Range.Column
Cells(Roww, Coll).Select
--
Earl Kiosterud
www.smokeylake.com

"Dennis" wrote in message
...
XL 2003

What VBA code line would return the cell address of the cell containing
the
AutoFilter dropdown box in a particular column

The line below does not work but gives an idea what I am looking for.

ActiveSheet.Autofilter.Address

Dennis