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